order management(om)important tables in oracle apps

--ORDER MANAGEMENT IMPORTANT TABLES

--ENTERNED

Select * from   OE_ORDER_HEADERS_ALL

Select * from   OE_ORDER_LINES_ALL

--BOOKED

Select * from   OE_ORDER_HEADERS_ALL

Select * from   OE_ORDER_LINES_ALL

Select * from   WSH_DELIVERY_DETAILS

--AUTO CREATE DELIVERIES

Select * from   WSH_NEW_DELIVERIES

--PICKED

Select * from   WSH_DELIVERY_DETAILS

Select * from   WSH_DELIVERY_ASSIGNMENTS

Select * from   WSH_PICKING_BATCHES

Select * from   MTL_MATERIAL_TRANSACTIONS

Select * from   MTL_RESERVATIONS

Select * from   MTL_TXN_REQUEST_HEADERS

Select * from   MTL_TXN_REQUEST_LINES

--SHIPPED

Select * from   OE_ORDER_LINES_ALL

Select * from   WSH_DELIVERY_DETAILS

Select * from   MTL_MATERIAL_TRANSACTIONS

--CLOSED    --YOU NEED TO RUN WORKFLOW BACKGROUND PROCESS

--ITEM_TYPE:-OM ORDER_LINE-----TO CLOSE THE LINE

--ITEM_TYPE:--OM ORDER_HEADER------TO CLOSE THE HEADER

Select * from   OE_ORDER_HEADERS_ALL  --FLOW_STATUS_CODE-:CLOSED

Select * from   OE_ORDER_LINES_ALL    --FLOW_STATUS_CODE-:CLOSED

Select * from   WSH_DELIVERY_DETAILS    --STATUS:-C

--AR INTERFACE_TABLES        ----->WORKFLOW BACKGROUND PROCESS
--WILL TRANSAFER THE RECORDS FROM OM TO AR INTERFACE TABLES
--SOURCE=ORDER_ENTRY

Select * from   RA_INTERFACE_LINES_ALL

Select * from   RA_INTERFACE_DISTRIBUTIONS_ALL

--AR BASE TABLES   --AUTO INVOICE IMPORT PROGRAM WILL 
--BE RUN THEN RECORDS SHOULD BE PRESENT IN AR BASE TABLES

Select * from   RA_CUSTOMER_TRX_ALL

Select * from   RA_CUSTOMER_TRX_LINES_ALL

Select * from   RA_CUST_TRX_LINE_GL_DIST_ALL

--CUSTOMERS

Select * from   HZ_PARTIES

Select * from   HZ_CUST_ACCOUNTS

--CUSTOMER SITES

Select * from   HZ_PARTY_SITES

Select * from   HZ_LOCATIONS

--SITE PURPOSES

Select * from   HZ_CUST_ACCT_SITES_ALL

Select * from   HZ_CUST_SITE_USES_ALL

--ORDER TYPES

Select * from   OE_TRANSACTION_TYPES_TL

--SALES REPS

Select * from   RA_SALESREPS_ALL

--CHARGES

Select * from   OE_CHARGE_LINES_V

--PRICE LIST

Select * from   QP_LIST_HEADERS

Select * from   QP_LIST_LINES

Select * from   QP_PRICING_ATTRIBUTES

--BANKS

Select * from   AP_BANK_ACCOUNTS_ALL

--BANK BRANCHES

Select * from   AP_BANK_ACCOUNT_USES_ALL

--BANK ACCT USES

Select * from AP_BANK_BRANCHES