Order To Cash Cycle Flow with queries

SN	Process	Remarks	Query
1	Enter Order	Flow status : Header: Entered line: Entered	SELECT HEADER_ID ,ORDER_NUMBER ,FLOW_STATUS_CODE ,ORDER_CATEGORY_CODE ,BOOKED_FLAG ,ORG_ID FROM oe_order_headers_all WHERE order_number = 66465	SELECT HEADER_ID ,LINE_ID ,LINE_TYPE_ID ,FLOW_STATUS_CODE ,LINE_NUMBER ,ORDERED_ITEM ,ORDERED_QUANTITY ,UNIT_LIST_PRICE_PER_PQTY FROM OE_ORDER_LINES_ALL WHERE 1=1 AND HEADER_ID = 192535
2	Book Order	Header :Booked Line: Awaiting Shipping Record(s) will be created in the table WSH_DELIVERY_DETAILS with RELEASED_STATUS=’R’ (Ready to Release) Also Record(s) will be inserted into WSH_DELIVERY_ASSIGNMENTS. SELECT * FROM WSH_DELIVERY_ASSIGNMENTS At the same time DEMAND INTERFACE PROGRAM runs in the background and inserts into MTL_DEMAND select * from MTL_DEMAND BackGround Program: Demand Interface program	SELECT HEADER_ID ,ORDER_NUMBER ,FLOW_STATUS_CODE ,ORDER_CATEGORY_CODE ,BOOKED_FLAG ,ORG_ID FROM oe_order_headers_all WHERE order_number = 66465	SELECT HEADER_ID ,LINE_ID ,LINE_TYPE_ID ,FLOW_STATUS_CODE ,LINE_NUMBER ,ORDERED_ITEM ,ORDERED_QUANTITY ,UNIT_LIST_PRICE_PER_PQTY FROM OE_ORDER_LINES_ALL WHERE 1=1 AND HEADER_ID = 192535
3	Pick Release	Header :Booked Line : Pick Confirmed If Auto create Delivery is set to ‘Yes’ then a new record is created in the table WSH_NEW_DELIVERIES DELIVERY_ID is populated in the table WSH_DELIVERY_ASSIGNMENTS. The RELEASED_STATUS in WSH_DELIVERY_DETAILS would be now set to ‘Y’ (Pick Confirmed) if Auto Pick Confirm is set to Yes otherwise RELEASED_STATUS is ‘S’ (Release to Warehouse). Back Ground Program: Pick Slip Report Shipping Execution Report Auto Pack Report Line: Pick Confirmed	SELECT DELIVERY_DETAIL_ID ,SOURCE_HEADER_ID ,SOURCE_LINE_ID ,CUSTOMER_ID ,INVENTORY_ITEM_ID ,RELEASED_STATUS FROM WSH_DELIVERY_DETAILS WHERE 1=1 AND SOURCE_HEADER_ID = 192535 ----------------------------------------------- SELECT * FROM WSH_NEW_DELIVERIES WHERE 1=1 AND DELIVERY_ID = 3773405 ORDER BY CREATION_DATE DESC -------------------------------------------------- SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE 1=1 AND DELIVERY_DETAIL_ID = 3962503 ORDER BY CREATION_DATE DESC
4	Pick Confirm	Header: Booked Line : Pick Confirmed
5	Ship Confirm	Header Booked Line : Shipped RELEASED_STATUS in WSH_DELIVERY_DETAILS would be ‘C’ (Ship Confirmed) FLOW_STATUS_CODE in OE_ORDER_HEADERS_ALL would be “BOOKED“ FLOW_STATUS_CODE in OE_ORDER_LINES_ALL would be “SHIPPED“ Back Ground Programss: Interface Trip Stop Commercial Invoice Packing Slip Report Bill Of Lading	SELECT HEADER_ID ,ORDER_NUMBER ,FLOW_STATUS_CODE ,ORDER_CATEGORY_CODE ,BOOKED_FLAG ,ORG_ID FROM oe_order_headers_all WHERE order_number = 66435 ------------------------------ SELECT HEADER_ID ,LINE_ID ,LINE_TYPE_ID ,FLOW_STATUS_CODE ,LINE_NUMBER ,ORDERED_ITEM ,ORDERED_QUANTITY ,UNIT_LIST_PRICE_PER_PQTY FROM OE_ORDER_LINES_ALL WHERE 1=1 AND HEADER_ID = 192535 --------------------------------- SELECT DELIVERY_DETAIL_ID ,SOURCE_HEADER_ID ,SOURCE_LINE_ID ,CUSTOMER_ID ,INVENTORY_ITEM_ID ,RELEASED_STATUS FROM WSH_DELIVERY_DETAILS WHERE 1=1 AND SOURCE_HEADER_ID = 192535
6	Invoice	Header :closed lines: Closed INTERFACE_LINE_CONTEXT     =     ’ORDER ENTRY’ INTERFACE_LINE_ATTRIBUTE1=     Order_number INTERFACE_LINE_ATTRIBUTE3=     Delivery_id RA_CUSTOMER_TRX_ALL will have the Invoice header information. The column INTERFACE_HEADER_ATTRIBUTE1 will have the Order Number. RA_CUSTOMER_TRX_LINES_ALL will have the Invoice lines information. The column INTERFACE_LINE_ATTRIBUTE1 will have the Order Number. Background Programs: Auto Invoice Master Programs Auto Invoice Import Programs	SELECT * FROM RA_INTERFACE_LINES_ALL WHERE 1=1 AND INTERFACE_LINE_CONTEXT = 'ORDER ENTRY' AND INTERFACE_LINE_ATTRIBUTE1 = 66435 AND INTERFACE_LINE_ATTRIBUTE3 = 3773405 ------------------------------------ SELECT CUSTOMER_TRX_ID ,TRX_NUMBER ,INTERFACE_HEADER_ATTRIBUTE1 ,INTERFACE_HEADER_ATTRIBUTE2 ,INTERFACE_HEADER_ATTRIBUTE3 ,INTERFACE_HEADER_CONTEXT ,STATUS_TRX FROM RA_CUSTOMER_TRX_ALL WHERE 1=1 AND INTERFACE_HEADER_CONTEXT = 'ORDER ENTRY' AND INTERFACE_HEADER_ATTRIBUTE1 = '66435' AND INTERFACE_HEADER_ATTRIBUTE3 = 3773405 ORDER BY CREATION_DATE DESC ------------------------------------------------------------------ SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL WHERE 1=1 AND TRX_NUMBER = ’10037546’ AND INTERFACE_LINE_CONTEXT = 'ORDER ENTRY' AND INTERFACE_LINE_ATTRIBUTE1 = 66435 AND INTERFACE_LINE_ATTRIBUTE3 = 3773405 ORDER BY CREATION_DATE DESC
7	Receipt		Underlying tables: SELECT * FROM AR_CASH_RECEIPTS_ALL WHERE 1=1 AND RECEIPT_NUMBER = 'R10037546' ORDER BY CREATION_DATE DESC -------------------------------- SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL WHERE 1=1 AND CASH_RECEIPT_ID = 113993 ORDER BY CREATION_DATE DESC -------------------------------- SELECT * FROM AR_PAYMENT_SCHEDULES_ALL WHERE 1=1 AND CASH_RECEIPT_ID = 113993 ORDER BY CREATION_DATE DESC
8	Transfer To GL
9	Journal Import
10	Posting