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

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