--------------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'
