ORDER TO CASH CYCLE IN ORACLE APPS TECHNICAL FLOW

  --------------ORDER TO CASH CYCLE IN ORACLE APPS TECHINICAL TABLES
==============================================================================
-- ENTER SALES ORDER  and BOOK SALES ORDER AFFECTING TABLES AND DETAILS
=============================================================================

SELECT order_number,
       header_id,
       flow_status_code,
       org_id
FROM   OE_ORDER_HEADERS_ALL
WHERE  ORDER_NUMBER = 1073413

SELECT HEADER_ID,
       LINE_ID,
       FLOW_STATUS_CODE,   ---Afte booking flow_status_code is AWAITING_SHIPPING
       INVENTORY_ITEM_ID
FROM   OE_ORDER_LINES_ALL
WHERE  HEADER_ID = '1530577'

SELECT  SOURCE_HEADER_ID,
        SOURCE_HEADER_NUMBER,
        DELIVERY_DETAIL_ID,
        SHIP_FROM_LOCATION_ID,
        SHIP_TO_LOCATION_ID,
        SHIPPED_QUANTITY,
        SUBINVENTORY,    ---Staging subinventory here
        RELEASED_STATUS,   --c -confirmed
        SHIP_METHOD_CODE
FROM     WSH_DELIVERY_DETAILS
WHERE  SOURCE_HEADER_ID = '1530577'

SELECT delivery_detail_id,
       delivery_id
FROM    WSH_DELIVERY_ASSIGNMENTS
WHERE DELIVERY_DETAIL_ID =877368931

=======================================================================
--- Relase Sales Order affecting Tables
====================================
SELECT
FROM    WSH_PICKING_BATCHES
WHERE ORDER_HEADER_ID =            --order header id = header_id

SELECT
FROM   WSH_NEW_DELIVERIES
WHERE  delivery_id = ''      -- delivery_id = delivery_id

========================================================================
------Shipping Sales Order--------
============================================

SELECT delivery_id
FROM  WSH_DELIVERY_LEGS
WHERE DELIVERY_ID = 1530577

SELECT
FROM    WSH_TRIP_STOPS
WHERE TRIP_ID =

SELECT
FROM    WSH_TRIPS
WHERE   STOP_ID IN()

=====================================================================
-----------AR AUTO INVOICE TABLES-------
======================================
SELECT   STATUS_TRX,
         INTERFACE_HEADER_ATTRIBUTE1,
         SHIP_TO_SITE_USE_ID,
         SHIP_TO_CONTACT_ID,
         SHIP_TO_CUSTOMER_ID,
         BILL_TO_SITE_USE_ID,
         BILL_TO_CUSTOMER_ID,
         SOLD_TO_SITE_USE_ID,
         SOLD_TO_CUSTOMER_ID,
         CUST_TRX_TYPE_ID,
         TRX_DATE,
         TRX_NUMBER,
         CUSTOMER_TRX_ID
FROM    RA_CUSTOMER_TRX_ALL
WHERE INTERFACE_HEADER_ATTRIBUTE1 = '1073413'               --order number

SELECT SALES_ORDER_SOURCE,   --ORDER ENTRY/ ANY OF AUTOMATION LIKE IF ANY MEHTOD
       AMOUNT_DUE_REMAINING,
       AMOUNT_DUE_ORIGINAL,
       LINE_TYPE,
       CUSTOMER_TRX_LINE_ID,
       DESCRIPTION,
       INVENTORY_ITEM_ID,
       QUANTITY_INVOICED,
       QUANTITY_ORDERED,
       UNIT_SELLING_PRICE,
       SALES_ORDER,
       SALES_ORDER_DATE,
       SALES_ORDER_LINE,
       REVENUE_AMOUNT,
       EXTENDED_AMOUNT
FROM    RA_CUSTOMER_TRX_LINES_ALL
WHERE customer_trx_id = '1865249'

SELECT     CUSTOMER_TRX_ID,
         CUST_TRX_LINE_GL_DIST_ID,
         CUSTOMER_TRX_LINE_ID,
         CODE_COMBINATION_ID,
         SET_OF_BOOKS_ID,
         CUST_TRX_LINE_SALESREP_ID,
         ACCOUNT_CLASS,
         CUSTOMER_TRX_ID,
         ACCTD_AMOUNT,
FROM    RA_CUST_TRX_LINE_GL_DIST_ALL
WHERE  CUSTOMER_TRX_ID = '1865249'

SELECT   REVENUE_AMOUNT_SPLIT,
         CUST_TRX_LINE_SALESREP_ID,
         CUSTOMER_TRX_ID,
         SALESREP_ID,
         CUSTOMER_TRX_LINE_ID
FROM    RA_CUST_TRX_LINE_SALESREPS_ALL
WHERE CUSTOMER_TRX_ID = '1865249'

SELECT  PAYMENT_SCHEDULE_ID,
        DUE_DATE,
        AMOUNT_DUE_ORIGINAL,
        AMOUNT_DUE_REMAINING,
        NUMBER_OF_DUE_DATES,
        STATUS,
        CLASS CLS,            --TYPE OF TRANSACTIONS INVOICE/CREDITMENO/DEBITMENO ......
        CUST_TRX_TYPE_ID,
        CUSTOMER_ID,
        CUSTOMER_SITE_USE_ID,
        CUSTOMER_TRX_ID,
        CASH_RECEIPT_ID,
        GL_DATE_CLOSED,
        ACTUAL_DATE_CLOSED,
        AMOUNT_APPLIED,
        AMOUNT_ADJUSTED,
        AMOUNT_IN_DISPUTE,
        AMOUNT_CREDITED,
        FREIGHT_REMAINING,
        FREIGHT_ORIGINAL,
        TRX_DATE,
        TRX_NUMBER,
        ACCTD_AMOUNT_DUE_REMAINING,
        PAYMENT_APPROVAL
FROM    AR_PAYMENT_SCHEDULES_ALL
WHERE CUSTOMER_TRX_ID = '1865249'