Skip to main content

Important Join conditions between Oracle apps modules

Book mark this page...to find more and more useful join conditions in upcoming days!!!!!!!!

Module

Table

Column

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
PO_REQUISITION_LINES_ALL
MTL_SYSTEM_ITEMS_B
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_LINES_ALL
WSH_DELIVARY_DETAILS
Line_id
Source_line_id
AP and AR (Banks)
AR_CASH_RECEIPTS_ALL
AP_BANK_ACCOUNTS
Remittance_bank_account_id
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

Book mark this page...to find more and more useful join conditions in upcoming days!!!!!!!!

Click the links below to find join condition......











Comments

  1. can anybody please provide the differences between Intercompany sales query and Account receivables queries

    ReplyDelete
    Replies
    1. Please find below query for account receivables data


      SELECT
      ACCOUNT_NAME,
      ACCOUNT_NUMBER,
      RCT.TRX_NUMBER,
      EXTENDED_AMOUNT,
      GROSS_EXTENDED_AMOUNT,
      RCTD.GL_DATE
      FROM
      HZ_CUST_ACCOUNTS HCA,
      RA_CUSTOMER_TRX RCT,
      RA_CUSTOMER_TRX_LINES RCTL,
      RA_CUST_TRX_LINE_GL_DIST_ALL RCTD
      WHERE HCA.CUST_ACCOUNT_ID=RCT.BILL_TO_CUSTOMER_ID
      AND RCT.CUSTOMER_TRX_ID=RCTL.CUSTOMER_TRX_ID
      AND RCTL.CUSTOMER_TRX_LINE_ID=RCTD.CUSTOMER_TRX_LINE_ID

      Delete

Post a Comment

Popular posts from this blog

Create Accounting for a Payment generates errors 95333 and 95359

Create Accounting for a Payment generates errors 95333 and 95359 Error: 95333: A conversion rate does not exist to convert USD to AUD for the conversion type Corporate and conversion date 20-MAR-09 for line -25. Please use the Daily Rates form in General Ledger to enter a conversion rate for these currencies, conversion date and conversion type. 95359: There is no accounted amount for the subledger journal entry line. Please inform your system administrator or support representative that: The source assigned to the accounting attribute Accounted Amount has no value for extract line number 88547. Please make sure the source assigned to the accounting attribute Accounted Amount has a valid value, or assign a different source to this accounting attribute. Solution: 1. Specify a conversion rate for the currencies and conversion date mentioned in the error message 95333 Navigation under the General Ledger responsibility: Setup > Currencies > Currency Rates Manager > Daily Rates ...

Public API’s for FA Transactions

Public API’s for FA Transactions So far Oracle FA is have all the good things except the lack on reporting.Oracle FA is now offer lot of public API's that can be used to interfacing with third party or Oracle application other modules. Here are some of transaction's API's:   Additions API if you have requirement to add assets directly via PL/SQL then use  FA_ADDITION_PUB.DO_ADDITION. If you have selected the Allow CIP Assets check box on the Book Controls window of a tax book when adding CIP assets using the Additions API, the this API automatically adds those CIP assets to that tax book at the same time that they are added to the corporate book. Adjustments API you can make cost adjustments to your assetsdirectly via PL/SQL using  FA_ADJUSTMENT_PUB.DO_ADJUSTMENT  for any  process adjustment. Detail can be found in appendix H) You can use this API if you have a custom interface that makes it difficult to use with the existing Oracle Assets interfaces for adjusti...

AP Table Relation Oracle Apps

AP Table Relation Oracle Apps ORACLE PAYABLE TABLE RELATION Source Table Dependent Table Condition AP_INVOICE_LINES_ALL AIL ZX_LINES_SUMMARY ZLS AIL.invoice_id = ZLS.trx_id and  ZLS.application_id  = 200 and  ZLS.entity_code  = 'AP_INVOICES' and  ZLS.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.summary_tax_line_id = ZLS.summary_tax_line_id AP_INVOICE_LINES_ALL AIL ZX_LINES ZL AIL.invoice_id = ZL.trx_id and  ZL.application_id  = 200 and  ZL.entity_code  = 'AP_INVOICES' and  ZL.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and  AIL.line_number = ZL.trx_line_number AP_INVOICE_DISTRIBUTIONS_ALL AID ZX_REC_NREC_DIST ZD AID.invoice_id = ZD.trx_id and  ZD.application_id  = 200 and  ZD.entity_code  = 'AP_INVOICES' and  ZD.event_class_code  in ('STANDARD INVOICES', 'PREPAYMENT INVOICES', 'EXPENSE REPORTS') and...