Forms trigger Firing Sequence

Forms trigger Firing Sequence

Introduction
------------

This document lists the order in which triggers fire in Oracle Forms 4.5:
o The first column, Action, describes the function to be performed
(e.g. deleting a record).
o The second column, Trigger Firing Order, describes the order
in which triggers fire after a function is performed.
o The third column, Level, describes the level (form, block, item)
at which the trigger fires. This was accomplished by creating a form
with all the triggers invoked. If a trigger could fire at all levels,
it was included at all levels. Such a trigger fires at the lowest level
at which it is defined.

Key triggers and triggers which fire via buttons or check boxes are
not included.

This bulletin does not cover every contingency and covers only the
most commonly used actions.

Action Trigger Firing Order Level

------ -------------------- -----

Runform 

1. Pre-Logon Form
2. On-Logon Form
3. Post-Logon Form
4. Pre-Form Form
5. When-Create-Record Block
6. Pre-Block Block
7. Pre-Record Block
8. Pre-Text-Item Item
9. When-New-Form-Instance Form
10. When-New-Block-Instance Block
11. When-New-Record-Instance Block
12. When-New-Item-Instance Item

***********

Enter Query 

1. Post-Text-Item Item
2. Post-Record Block
3. When-Clear-Block Block
4. When-New-Record-Instance Block
5. When-New-Item-Instance Item

Note: If you define the Key-ENTQRY trigger, this is the only trigger
which fires in an Enter Query situation.


*****************

Execute Query

After Enter Query 1. Pre-Query Block
2. Pre-Select Block
3. On-Select Block
4. When-Clear-Block Block
5. Post-Select Block
6. On-Fetch Block
7. On-Close Form
8. When-Clear-Block Block

Note: If you define the Key-EXEQRY trigger, this is the only trigger
which fires in an Execute Query situation.


*************

Execute Query Without Enter

Query 1. Post-Text-Item Block
2. Pre-Query Block
3. Pre-Select Block
4. On-Select Block
5. Post-Select Block
6. On-Fetch Block
7. On-Close Form
8. When_Create_Record Block
9. Pre-Record Block
10. Pre-Text-Item Item
11. When-New-Record-Instance Block
12. When-New-Item-Instance Item


****

Exit 1. Post-Text-Item Item

2. Post-Record Block
3. Post-Block Block
4. Post-Form Form
5. On-Rollback Form
6. Pre-Logout Form
7. On-Logout Form
8. Post-Logout Form


**************

Next Field and Previous field 

1. When-New-Item-Instance Item


***************

Next Record and Previous Record 

1. When-New-Record-Instance Block
2. When-New-Item-Instance Item

**************

Next Block and Previous Block 

1. Post-Text-Item Item
2. Post-Record Block
3. Post-Block Block
4. When-Create-Record Block
5. Pre-Block Block
6. Pre-Record Block
7. Pre-Text-Item Block
8. When-New-Block-Instance Block
9. When-New-Record-Instance Block
10. When-New-Item-Instance Form


*******************

Records Are Queried 

1. Post-Query Block
2. Post-Change Block
3. Post-Change Item
4. Post-Change Block
5. Post-Change Block
Go back to Post-Query

NOTE: This cycle is repeated for each record retrieved.


**********************

No Records Are Queried 

1. When-New-Record-Instance Block
2. When-New-Item-Instance Item

NOTE: To observe this Trigger Firing Order:
a. Enter a query.
b. Enter a nonexistent record.
c. Execute the query.

The two triggers listed above, the Enter Query triggers, and
the Execute Query triggers fire.


*************

Create Record 

1. Post-Change Block
2. When-Validate-Item Block
3. Post-Text-Item Block
4. When-Validate-Record Block
5. Post-Record Block
6. Post-Block Block
7. On-Savepoint Form
8. Pre-Commit Form
9. Pre-Insert Block
10. On-Insert Form
11. Post-Insert Block
12. Post-Forms-Commit Form
13. On-Commit Form
14. Post-Database-Commit Form
15. Pre-Block Block
16. Pre-Record Block
17. Pre-Text-Item Block
18. When-New-Item-Instance Form


*************

Update Record 

1. When-Database-Record Block
2. Post-Change Block
3. When-Validate-Item Block
4. Post-Text-Item Block
5. When-Validate-Record Block
6. Post-Record Block
7. Post-Block Block
8. On-Savepoint Form
9. Pre-Commit Form
10. Pre-Update Block
11. On-Update Block
12. Post-Update Block
13. Post-Forms-Commit Form
14. On-Commit Form

Here the transaction is complete and one record added.

15. Post-Database-Commit Form
16. Pre-Text-Item Block
17. When-New-Item-Instance Form

NOTE: To observe this Trigger Firing Order:

a. Execute a query.
b. Change a value.
c. Choose Action->Save from the menu.
d. Record the triggers from that point.


*************

Delete Record

1. On-Lock Block
2. When-Remove-Record Block
3. Post-Change Block
4. Post-Change Block
5. Post-Change Block
6. Post-Change Block
7. Post-Change Block
8. Post-Change Block
9. Post-Change Item
10. Post-Query Block
11. Post-Text-Item Block
12. Post-Record Block
13. Pre-Record Block
14. Pre-Text-Item Block
15. When-New-Record-Instance Block
16. When-New-Item-Instance Form

NOTE: To observe this Trigger Firing Order, delete a detail record.

Improve the performance of SQL*Loader

Can one improve the performance of SQL*Loader?
A very simple but easily overlooked hint is not to have any indexes and/or constraints (primary key) on your load tables during the load process. This will significantly slow down load times even with ROWS= set to a high value.
Add the following option in the command line: DIRECT=TRUE. This will effectively bypass most of the RDBMS processing. However, there are cases when you can't use direct load. Refer to chapter 8 on Oracle server Utilities manual.
Turn off database logging by specifying the UNRECOVERABLE option. This option can only be used with direct data loads.
Run multiple load jobs concurrently.

How to invoke an Oracle apps form from a workflow notification

How to invoke an Oracle apps form from a workflow notification

Open Document functionality is a standard functionality within Oracle workflow. This functionality allows the user to go a particular transaction directly from the notification. The user gets to see a link in the workflow notification. On clicking this link he/she is directly taken to the Oracle form. The form opens and automatically queries the data for the user to view.


This functionality exists in seeded workflows. We can use this functionality within custom workflows to allow the users view the data directly in Apps from the notification.

We would like to show a particular GL journal to the user from our custom workflow. The journal is shown below.

Journal

We will check the Journal Header ID as this is the primary key that will be used to uniquely identify the data and will be used in querying the form once it opens from the notification.

Click on Help > Diagnostics > Examine

We get Header ID = 979869.

Step 1: Oracle Form check

Now we need to check the form name and the function name. Click on Help > Diagnostics > Custom Code > Personalize.

Note the Form and Function name. The Function name is GLXJEENT_A and the form name is GLXJEENT.

We have to check the parameters for the form so that we can pass the right values into it. To do so, we need to download the form down into our local computer so that we can open the form in Forms Builder to identify the parameters. We shall download the form,GLXJEENT.fmb, from $AU_TOP/forms/US directory on the server. After downloading and opening the form we shall open the Parametersection. It will look like the following,

We need to pass values into some of the form parameters displayed above. For this form we have to pass values into 3 parameters,

• AUTOQUERY_LEVEL
• AUTOQUERY_COORDINATION
• AUTOQUERY_CRITERIA

Check the properties of each of the parameters

• AUTOQUERY_LEVEL

• AUTOQUERY_COORDINATION

• AUTOQUERY_CRITERIA

From the properties of the parameters we will get to know what kind of values to pass.

Step 2: Develop the workflow

Develop a workflow in the Workflow Builder. This will be a very simple workflow that will send an approval message to an approver who will get the Form link in the notification. We have created our workflow type, Test Form from Workflow, and the Internal name isTESTFORM.

Main features of the workflow are,

1. Attribute for storing the Journal Header id
2. Attribute to store the Form link
3. Attribute to store the approver number
4. Approval message
5. Approval notification
6. Approval process

The workflow is shown below.

Check the attribute, View Journal form.

Note that the type of this attribute is Form. Also note the value. It is set to GLXJEENT_A:AUTOQUERY_LEVEL=”JOURNAL” AUTOQUERY_COORDINATION=”INITIAL” autoquery_criteria=”&JE_HEADER_ID”.

Important:
Format for invoking a form is,

<Function Name>:<Param1>=”&WF_ATTRIBUTE1″ <Param2>=”&WF_ATTRIBUTE 2″….

We need to pass the values of the form parameters into the form function as given above and workflow will identify the form from the function and invoke it from the notification.

Ensure that the View Journal Form attribute is attached to the workflow message along with the other attributes, Journal Header ID andApprover Number. The properties of the View Journal Form attribute on the message level is,

The message is set as

The workflow process is

After the development is done, save the workflow into the database.

Step 3: Test the workflow

Login to Oracle and go to Workflow Administrator responsibility. Then navigate to Developer Studio tab.

Enter the Workflow Type = Test Form from Workflow or the Internal Name as TESTFORM. Then click on Go button.

You will get to see the workflow now. Click on the Run icon. Now you will be taken to the workflow initiation screen. Enter the values forItem Key, Journal header ID and Approver Number fields as these values are essential to the workflow. The value for View Journal Form workflow attribute will be automatically populated from the workflow itself.

Point: We have passed the Journal Header ID for the journal that we had viewed at the beginning of this article so that we can verify the results.

Click on Submit button. You will get a confirmation message.

Click on OK. Then click on Status Monitor tab.

Enter the following on Status Monitor,

Type Internal Name: TESTFORM

Item Key: TEST10013

Click on Go

Click on Select and then Activity History. Now all the activities are shown and we see that workflow has sent the notification to the approver.

Click on the Notification icon.

Now the notification is displayed. You can now see the link, View Journal Form, on the bottom left of the screen.

Note:
The link name is always same as the attribute name.

Click on the link, View Journal Form.

Now the Oracle Apps form applet opens and we are prompted for a responsibility. Since we are about to view a Journal we need to select a General Ledger responsibility.

When we click on OK. The responsibility changes and the Journal form opens with the details of the Journal.

The link we created to the form is working perfectly. The same method can be used to invoke other seeded forms as well as custom forms.

P2P Flow SQL Query Link

R12

/* Formatted on 7/10/2014 9:13:18 AM (QP5 v5.256.13226.35510) */
SELECT prh.segment1 "PO Requisition Number"
     , pha.segment1 "PO Number"
     , aps.SEGMENT1 "Supplier Number"
     , aps.vendor_name
     , apss.vendor_site_code
     , apsc.first_name
     , apsc.last_name
     , pla.item_id
     , plla.ship_to_organization_id
     , plla.ship_to_location_id
     , rt.transaction_type
     , rt.destination_type_code
     , rsh.receipt_num "PO Receipt Number"
     , aia.invoice_num
     , aida.dist_code_combination_id
     , aca.check_number
     , gjh.ledger_id
     , gjh.name
  FROM po_requisition_headers_all prh
     , po_requisition_lines_all prl
     , po_req_distributions_all prd
     , po_headers_all pha
     , po_lines_all pla
     , po_distributions_all pda
     , po_line_locations_all plla
     , ap_suppliers aps
     , ap_supplier_sites_all apss
     , ap_supplier_contacts apsc
     , rcv_transactions rt
     , rcv_shipment_headers rsh
     , rcv_shipment_lines rsl
     , ap_invoices_all aia
     , ap_invoice_lines_all aila
     , ap_invoice_distributions_all aida
     , ap_invoice_payments_all aipa
     , ap_checks_all aca
     , xla.xla_transaction_entities xte
     , xla_events xe
     , xla_ae_headers xah
     , xla_ae_lines xal
     , xla_distribution_links xdl
     , gl_import_references gir
     , gl_je_batches gjb
     , gl_je_headers gjh
     , gl_je_lines gjl
 WHERE prh.segment1 = :RequitionNumber --Right click :RequitionNumber from Toad Enable Prompt For Substitution Variables
   AND aps.vendor_id = pha.vendor_id
   AND apss.vendor_id = aps.vendor_id
   AND apss.vendor_site_id(+) = pha.vendor_site_id
   AND apss.vendor_site_id = aca.vendor_site_id
   AND apsc.vendor_site_id = apss.vendor_site_id
   AND apsc.vendor_contact_id = pha.vendor_contact_id
   AND prl.requisition_header_id = prh.requisition_header_id
   AND prd.requisition_line_id = prl.requisition_line_id
   AND pda.req_distribution_id = prd.distribution_id
   AND pla.po_header_id = pda.po_header_id
   AND pla.po_line_id = pda.po_line_id
   AND pha.po_header_id = pla.po_header_id
   AND pha.org_id = 204
   AND plla.po_header_id = pla.po_header_id
   AND plla.po_line_id = pla.po_line_id
   AND rt.transaction_type = 'DELIVER'
   AND rt.po_header_id = pha.po_header_id
   AND rt.po_line_id = pla.po_line_id
   AND rsh.shipment_header_id = rt.shipment_header_id
   AND rsl.shipment_header_id = rsh.shipment_header_id
   AND rsl.shipment_line_id = rt.shipment_line_id
   AND aila.po_header_id = pha.po_header_id
   AND aila.po_line_id = pla.po_line_id
   AND aia.invoice_id = aila.invoice_id
   AND aida.invoice_id = aila.invoice_id
   AND aida.invoice_line_number = aila.line_number
   AND aipa.invoice_id = aia.invoice_id
   AND aca.check_id = aipa.check_id
   AND xte.entity_code = 'AP_PAYMENTS'
   AND xte.transaction_number = aca.check_number
   AND xte.source_id_int_1 = aipa.check_id
   AND xte.security_id_int_1 = aia.org_id
   AND xe.entity_id = xte.entity_id
   AND xah.event_id = xe.event_id
   AND xal.ae_header_id = xah.ae_header_id
   AND xal.ae_line_num = aida.invoice_line_number
   AND xdl.ae_header_id = xah.ae_header_id
   AND xdl.ae_line_num = xal.ae_line_num
   AND xdl.applied_to_dist_id_num_1 = aida.invoice_distribution_id
   AND gir.reference_5 = xte.entity_id                            -- Entity Id
   AND gir.reference_6 = TO_CHAR (xe.event_id)                      --Event Id
   AND gir.reference_7 = TO_CHAR (xah.ae_header_id)            -- AE Header Id
   AND gir.gl_sl_link_id = xal.gl_sl_link_id
   --and gir.created_by = 1318
   AND gjb.je_batch_id = gir.je_batch_id
   AND gjh.je_batch_id = gjb.je_batch_id
   AND gjh.je_header_id = gir.je_header_id
   AND gjl.je_header_id = gjh.je_header_id

   AND gjl.je_line_num = gir.je_line_num

11i

/* Formatted on 7/10/2014 9:22:34 AM (QP5 v5.256.13226.35510) */
SELECT A.ORG_ID "ORG ID"
     , E.VENDOR_NAME "VENDOR NAME"
     , UPPER (E.VENDOR_TYPE_LOOKUP_CODE) "VENDOR TYPE"
     , F.VENDOR_SITE_CODE "VENDOR SITE"
     , F.ADDRESS_LINE1 "ADDRESS"
     , F.CITY "CITY"
     , F.COUNTRY "COUNTRY"
     , TO_CHAR (TRUNC (D.CREATION_DATE)) "PO DATE"
     , D.SEGMENT1 "PO NUMBER"
     , D.TYPE_LOOKUP_CODE "PO TYPE"
     , C.QUANTITY_ORDERED "QTY ORDERED"
     , C.QUANTITY_CANCELLED "QTY CANCALLED"
     , G.ITEM_DESCRIPTION "ITEM DESCRIPTION"
     , G.UNIT_PRICE "UNIT PRICE"
     ,   (NVL (C.QUANTITY_ORDERED, 0) - NVL (C.QUANTITY_CANCELLED, 0))
       * NVL (G.UNIT_PRICE, 0)
          "PO Line Amount"
     , (SELECT DECODE (PH.APPROVED_FLAG, 'Y', 'Approved')
          FROM PO.PO_HEADERS_ALL PH
         WHERE PH.PO_HEADER_ID = D.PO_HEADER_ID)
          "PO STATUS"
     , A.INVOICE_TYPE_LOOKUP_CODE "INVOICE TYPE"
     , A.INVOICE_AMOUNT "INVOICE AMOUNT"
     , TO_CHAR (TRUNC (A.INVOICE_DATE)) "INVOICE DATE"
     , A.INVOICE_NUM "INVOICE NUMBER"
     , (SELECT DECODE (X.MATCH_STATUS_FLAG, 'A', 'Approved')
          FROM AP.AP_INVOICE_DISTRIBUTIONS_ALL X
         WHERE X.INVOICE_DISTRIBUTION_ID = B.INVOICE_DISTRIBUTION_ID)
          "Invoice Approved?"
     , A.AMOUNT_PAID
     , H.AMOUNT
     , I.CHECK_NUMBER "CHEQUE NUMBER"
     , TO_CHAR (TRUNC (I.CHECK_DATE)) "PAYMENT DATE"
  FROM AP.AP_INVOICES_ALL A
     , AP.AP_INVOICE_DISTRIBUTIONS_ALL B
     , PO.PO_DISTRIBUTIONS_ALL C
     , PO.PO_HEADERS_ALL D
     , PO.PO_VENDORS E
     , PO.PO_VENDOR_SITES_ALL F
     , PO.PO_LINES_ALL G
     , AP.AP_INVOICE_PAYMENTS_ALL H
     , AP.AP_CHECKS_ALL I
 WHERE A.INVOICE_ID = B.INVOICE_ID
   AND B.PO_DISTRIBUTION_ID = C.PO_DISTRIBUTION_ID(+)
   AND C.PO_HEADER_ID = D.PO_HEADER_ID(+)
   AND E.VENDOR_ID(+) = D.VENDOR_ID
   AND F.VENDOR_SITE_ID(+) = D.VENDOR_SITE_ID
   AND D.PO_HEADER_ID = G.PO_HEADER_ID
   AND C.PO_LINE_ID = G.PO_LINE_ID
   AND A.INVOICE_ID = H.INVOICE_ID
   AND H.CHECK_ID = I.CHECK_ID
   AND F.VENDOR_SITE_ID = I.VENDOR_SITE_ID
   AND C.PO_HEADER_ID IS NOT NULL
   AND A.PAYMENT_STATUS_FLAG = 'Y'
   AND D.TYPE_LOOKUP_CODE != 'BLANKET';

Joins Between Oracle Apps Tables Like General Ledger(GL) , Account Payable(AP), Account Receivables(AR), Purchasing Orader(PO)

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
Po_Requisition_Headers_All
Column Names                   Table Name                                  Column Name
REQUISITION_HEADER_IDPO_REQUISITION_LINES_ALL    REQUISITION_HEADER_ID
TYPE_LOOKUP_CODE        PO_DOCUMENT_TYPES             DOCUMENT_SUBTYPE
PREPARER_ID                   PER_PEOPLE_F                           PERSON_ID
ORG_ID                             MTL_SYSTEM_ITEMS               ORGANIZATION_ID
ORG_ID                             MTL_ORGANIZATIONS            ORGANIZATION_ID
Po_Requisition_Lines_All
Column Names                   Table Name                              Column Name
REQUISITION_HEADER_ID   PO_REQUISITION_HEADERS_ALL  REQUISITION_HEADER_ID
REQUISITION_LINE_ID      PO_REQ_DISTRIBUTIONS_ALL          REQUISITION_LINE_ID
LINE_TYPE_ID               PO_LINE_TYPES                                    LINE_TYPE_ID
ITEM_ID                          MTL_SYSTEM_ITEMS                        INVENTORY_ITEM_ID
ORG_ID                           MTL_SYSTEM_ITEMS                        ORGANIZATION_ID
Po_Requisition_Distributions_All
Column Names                      Table Name                                Column Name
REQUISITION_LINE_ID      PO_REQUISITION_LINES_ALL     REQUISITION_LINE_ID
DISTRIBUTION_ID            PO_DISTRIBUTIONS_ALL            REQ_DISTRIBUTION_ID
SET_OF_BOOKS_ID          GL_SETS_OF_BOOKS                     SET_OF_BOOKS_ID
CODE_COMBINATION_ID  GL_CODE-COMBINATIONS            CODE_COMBINATION_ID
Po_Distributions_All
Column Names                   Table Name                                         Column Name
PO_LINE_ID                   PO_LINES                                          PO_LINE_ID
REQ_DISTRIBUTION_ID   PO_REQ_DISTRIBUTIONS_ALL       DISTRIBUTION_ID
PO_DISTRIBUTION_ID    AP_INVOICE_DISTRIBUTIONS_ALL PO_DISTRIBUTION_ID
Po_Headers_All
Column Names                   Table Name                              Column Name
PO_HEADER_ID                PO_LINES                                 PO_HEADER_ID
PO_HEADER_ID                RCV_SHIPMENT_LINES           PO_HEADER_ID
VENDOR_ID                      PO_VENDORS                          VENDOR_ID
AGENT_ID                       PER_PEOPLE                           PERSON_ID
TYPE_LOOK_UP_CODE     PO_DOCUMENT_TYPES            DOCUMENT_SUBTYPE
Po_Lines_All
Column Names                   Table Name                                    Column Name
PO_HEADER_ID               PO_HEADERS                                PO_HEADER_ID
PO_LINE_ID                     PO_DISTRIBUTIONS_ALL           PO_LINE_ID
ITEM_ID                          MTL_SYSTEM_ITEMS                   ITEM_ID
Rcv_Shipment_Lines
Column Names                   Table Name                                  Column Name
PO_HEADER_ID                PO_HEADERS                              PO_HEADER_ID
SHIPMENT_HEADER_ID   RCV_SHIPMENT_HEADERS  SHIPMENT_HEADER_ID
Ap_Invoices_All
Column Names       Table Name                                          Column Name
INVOICE_ID             AP_INVOICE_DISTRIBUTIONS_ALL  INVOICE_ID
Oe_Order_Headers_All
Column Names                   Table Name                      Column Name
HEADER_ID                        OE_ORDER_LINES                   HEADER_ID
SOURCE_HEADER_ID          WISH_DELIVERY_DETAILS     SOURCE_HEADER_ID
PRICE_LIST_ID                   QP_LIST_HEADERS_TL           LIST_HEADER_ID
ORG_ID                              MTL_ORGANIZATIONS           ORGANIZATION_ID
SALESREP_ID                      JTF_RS_SALESREPS               SALESREP_ID
ORDER_TYPE_ID                  OE_TRANSACTION_TYPES     TRANSACTION_TYPE_ID
ORDER_SOURCE_ID             OE_ORDER_SOURCES             ORDER_SOURCE_ID
ACCOUNTING_RULE_ID        RA_RULES                               RULE_ID
PAYMENT_TERM_ID              RA_TERMS                              TERM_ID
SOLD_TO_ORG_ID               HZ_CUST_ACCOUNTS             CUST_ACCOUNT_ID
SHIP_FROM_ORG_ID            MTL_PARAMETERS                 ORGANIZATION_ID
SHIP_TO_ORG_ID                HZ_CUST_SITE_USES_ALL    SITE_USE_ID
Oe_Order_Lines_All
Column Names       Table Name                             Column Name
LINE_TYPE_ID            OE_TRANSACTION_TYPES_TL     TRANSACTION_TYPE_ID
INVOICING_RULE_ID  RA_RULES                                     RULE_ID
Hz_Parties
Column Names       Table Name                         Column Name
PATY_ID                    HZ_CUST_ACCOUNTS        PATY_ID
CUST_ACCOUNT_ID   OE_ORDER_LINES             SOLD_TO_ORG_ID
Hz_Party_Sites_All
Column Names                   Table Name                Column Name
PATY_ID                              HZ_PARTIES               PATY_ID
LOCATION_ID                     HZ_LOCATIONS         LOCATION_ID
Wsh_delivery_details
Column Names                 Table Name                              Column Name
SOURCE_HEADER_ID         OE_ORDER_HEADERS                    SOURCE_HEADER_ID
DELIVERY_DETAIL_ID        WSH_DELIVERY_ASSIGNMENTS   DELIVERY_DETAIL_ID
DELIVERY_ID                    WSH_NEW_DELIVERIES                DELIVERY_ID
INVENTORY_ITEM_ID        MTL_SYSTEM_ITEMS                     INVENTORY_ITEM_ID
RA_CUSTOMER_TRX_ALL
Column Names           Table Name                                    Column Name
CUSTOMER_TRX_ID     AR_RECEIVABLE_APPLICATIONS_ALL APPLIED_CUSTOMER_TRX_ID
TERM_ID                     RA_TERMS                                           TERM_ID
CUSTOMER_TRX_ID    RA_CUST_TRX_LINE_GL_DIST        CUSTOMER_TRX_ID
AR_CASH_REC EIPTS_ALL
Column Names                   Table Name                                   Column Name
CASH_RECEIPT_ID               AR_RECEIVABLE_APPLICATIONS_ALL  CASH_RECEIPT_ID
SET_OF_BOOKS_ID             GL_SETS_OF_BOOKS                               SET_OF_BOOKS_ID