JOIN CONDITIONS USED IN ORACLE APPS(GL,AP,AR,INV ETC) KEY JOINS

GL AND AP

GL_CODE_COMBINATIONS AP_INVOICES_ALL

code_combination_id = acct_pay_code_combination_id

GL_CODE_COMBINATIONS AP_INVOICES_DISTRIBUTIONS_ALL

code_combination_id = dist_code_combination_id

GL_SETS_OF_BOOKS AP_INVOICES_ALL

set_of_books_id = set_of_books_id

GL AND AR

GL_CODE_COMBINATIONS RA_CUST_TRX_LINE__GL_DIST_ALL

code_combination_id = code_combination_id

GL AND INV

GL_CODE_COMBINATIONS MTL_SYSTEM_ITEMS_B

code_combination_id = cost_of_sales_account

 

GL AND PO

GL_CODE_COMBINATIONS PO_DISTRIBUTIONS_ALL

code_combination_id = code_combination_id

PO AND AP

PO_DISTRIBUTIONS_ALL AP_INVOICE_DISTRIBUTIONS_ALL

Po_distribution_id = po_distribution_id

PO_VENDORS AP_INVOICES_ALL

vendor_id = vendor_id

PO AND SHIPMENTS

PO_HEADERS_ALL RCV_TRANSACTIONS

Po_header_id = po_header_id

PO_DISTRIBUTIONS_ALL RCV_TRANSACTIONS

Po_distribution_id = po_distribution_id

SHIPMENTS AND INVOICE

RCV_TRANSACTIONS AP_INVOICE_DISTRIBUTIONS_ALL

RCV_TRANSACTION_ID = RCV_TRANSACTION_ID

 PO AND INV

PO_REQUISITION_LINES_ALL MTL_SYSTEM_ITEMS_B

item_id = inventory_item_id

org_id = organization_id

PO AND HRMS

PO_HEADERS_ALL HR_EMPLOYEES

Agent_id = employee_id

PO AND REQUISITION

PO_DISTRIBUTIONS_ALL PO_REQ_DISTRIBUTIONS_ALL

req_distribution_id = distribution_id

 SHIPMENTS AND INV

RCV_TRANSACTIONS MTL_SYSTEM_ITEMS_B

Organization_id = organization_id

INV AND HRMS

MTL_SYSTEM_ITEMS_B HR_EMPLOYEES

buyer_id = employee_id

OM AND AR

OE_ORDER_HEADERS_ALL RA_CUSTOMER_TRX_LINES_ALL

TO_CHAR( Order_number) = interface_line_attribute1

OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL

TO_CHAR(Line_id) = interface_line_attribute6

OE_ORDER_LINES_ALL RA_CUSTOMER_TRX_LINES_ALL

reference_customer_trx_line_id = customer_trx_line_id

OM AND SHIPPING

OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS

HEADER_ID = SOURCE_HEADER_ID

OE_ORDER_HEADERS_ALL WSH_DELIVARY_DETAILS

LINE_ID = SOURCE_LINE_ID

AP AND AR (BANKS)

AR_CASH_RECEIPTS_ALL AP_BANK_ACCOUNTS

REMITTANCE_BANK_ACCOUNT_ID = ABA.BANK_ACCOUNT_ID

AP AND AR

HZ_PARTIES AP_INVOICES_ALL

PARTY_ID = PARTY_ID

OM AND CRM

OE_ORDER_LINES_ALL CSI_ITEM_INSTANCES(Install Base)

LINE_ID = LAST_OE_ORDER_LINE_ID