Links between oracle apps tables

Some links and tables of Oracle Apps modules

Some links of Oracle Apps modules
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