Protected by Copyscape Web Copyright Protection Software

Search This Blog

Saturday, June 8, 2013

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