Important Join conditions between Oracle apps modules

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 AP 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