ORDER TO CASH WORKFLOW CYCLE END TO END WITH BASE TABLES EFFECTED

CREATE A ITEM IN THE INVENTORY AND CHECK THE BACKEND TABLE==========================================================

NOW THE ITEM IS CREATED=======================

SELECT * FROM MTL_SYSTEM_ITEMS_B WHERE SEGMENT1 LIKE 'R2R%'

INCREASE THE QUANTITY OF THE ITEM =========================

SELECT * FROM  MTL_ONHAND_QUANTITIES WHERE INVENTORY_ITEM_ID='248207'

NOW GOT TO ORDER MANAGEMENT CREATE THE SALES ORDER ===========================================

SELECT * FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER='69380' -- FLOW_STATUS_CODE SHOWS THE ITEM IS 'ENTERED'THAT MEANS THAT ORDER HAS BEEN  CREADTED

SELECT * FROM OE_ORDER_LINES_ALL WHERE HEADER_ID='367828'-- THIS TABLE TELLS HOW MUCH QUANTITY THE ORDERS ARE CREATED

NOW THE SALES ORDERS ARE CREATED NOW WE HAVE TO BOOK THE SALES ORDERSNOW WE HAVE  TO BOOK THE SALES ORDERS THAT ARE CREATED AND CONFIRM THE ORDERS THAT ARE RECIEVED BY THE CUSTOMERS=================================================================================================================

SELECT * FROM OE_ORDER_HEADERS_ALL WHERE ORDER_NUMBER='69380' -- FLOW_STATUS_CODE SHOWS THE ITEM IS 'BOOKED' THAT MEANS THAT THE ORDER IS BOOKED

SELECT * FROM OE_ORDER_LINES_ALL WHERE HEADER_ID='367828'

NOW THE ORDERS ARE BOOKED NOW WE HAVE TO RELEASE THE SALES ORDERS WE CAN CHECK THE STATUS OF THE ORDERS IN THE ORDER ORGANISER, SEE BELOW NAVIGATIONNOW WHEN YOU GO TO ORDER RETURNS AND ORDER ORGANIZER==>ADDITIONAL INFORMATION==>DELIVERIES==>PICK STATUS==> READY TO RELEASE=============================================================================================================================

SELECT * FROM WSH_DELIVERY_DETAILS WHERE INVENTORY_ITEM_ID=248207-- RELEASED STATUS -'R'==> READY TO RELEASE

SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID=6228053

TO RELASE THE SALES ORDERS WE GO TO SHIPPING ==>RELEASE SALES ORDERS==> SALES ORDERS GIVE THE ORDER NUMBER AND RUN THE CONCURRENT PROGRAM THEN THE FOLLOWING JOBS KICK OFF===========================================================================================================================================================================

THEN THE EFFECTED BACKEND TABLES ARE --RELEASES STATUS-'s' ==>PICK RELEASE
SELECT * FROM WSH_DELIVERY_DETAILS WHERE INVENTORY_ITEM_ID=248207-- RELEASED STATUS -'Y'==> PICK CONFIRM


SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID=6228053


SELECT * FROM MTL_RESERVATIONS  WHERE INVENTORY_ITEM_ID=248207-- THIS TABLE TELLS THE INFORMATION THE INFORMATIONS HOW MUCH QUANTITY IS RESERVED  AT THE STAGING AREA AND THE DATA IN IT GETS FREEZED ONCE THE SALES ORDERS AEE SHIPPED


SELECT * FROM MTL_TXN_REQUEST_HEADERS WHERE REQUEST_NUMBER='6397347'-- THIS TABLE GIVES THE INFORMATION ABOUT THE QUANTITY OF THE SALES ORDER THAT ARE TRANSFERED FROM INVENTORY TO STAGING AREA


SELECT * FROM MTL_TXN_REQUEST_LINES WHERE HEADER_ID= '6397348'--EVEN THIS TABLE GIVES THE INFORMATION ABOUT THE ORDERS THAT ARE MOVED FROM INVENTORY TO STAGING AREA

NOW THE ABOVE SALES ORDERS ARE RELEASED NOW WE HAVE TO SHIP THE SALES ORDERS============================================================================
FOR THIS WE HAVE TO GO TO SHIPPING==>TRANSACTIONS==>GIVE THE ORDER NUMBER AND CONFIRM THE SHIP==========================================================================================

=====ONCE YOU CONFIRM THE SHIP IT KICKS OFF THE STANDRDS JOBS

THEN THE FOLLOWING TABNLES ARE EFFECTED IN THE BACKEND=======================================================

SELECT * FROM WSH_DELIVERY_DETAILS WHERE INVENTORY_ITEM_ID=248207-- RELEASED STATUS -'C'==> SHIP CONFIRMED


SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_DETAIL_ID=6228053


SELECT * FROM MTL_RESERVATIONS  WHERE INVENTORY_ITEM_ID=248207-- AT THIS STAGE WE DONT HAVE ANY DATA ONCE THE SALES ORDERS ARE SHIPPED


SELECT * FROM MTL_TXN_REQUEST_HEADERS WHERE REQUEST_NUMBER='6397347'-- THIS TABLE GIVES THE INFORMATION ABOUT THE QUANTITY OF THE SALES ORDER THAT ARE TRANSFERED FROM INVENTORY TO STAGING AREA


SELECT * FROM MTL_TXN_REQUEST_LINES WHERE HEADER_ID= '6397348'--EVEN THIS TABLE GIVES THE INFORMATION ABOUT THE ORDERS THAT ARE MOVED FROM INVENTORY TO STAGING AREA

NOW ONCE THE SALES ORDERS ARE SHIPPED THEN WE CAN CHECK THE STATUS OF THE ORDERS FROM ORDER ORGANIZER ==>ADDITIONAL INFORMATION==>DELIVERIERS==>VIEW DELIVERY DETAILSPICK STATUS==>SHIPPED
IF YOU SEE THYE DELIVERY LINE DETAILS WE SEE IT HAS INTERFACED IT MEANS THAT THE DATA OF THE SALES ORDERS ARE INTERFACD TO AR INTERFACE TABLES.

SELECT * FROM FND_TABLES WHERE TABLE_NAME LIKE 'RA%INTERFACE%'


SELECT * FROM RA_INTERFACE_LINES_ALL WHERE 
INTERFACE_LINE_ATTRIBUTE1='69380'--ORDER NUMBER AND INTERFACE_LINE_ATTRIBUTE3='6248833'--DELIVERY NUMBER

NOW WE HAVE TO RUN THE WORKFLOWBACKGROUND PROCESS THROUGH SRS WINDOW IN ORDER managemen TO TRANSFER THE ORDERS FROM ORDER MANAGEMENT MODULE TO ACCOUNT RECIEVABLES MODULE===============================================================================================================================================================

then once completed goto account recievables and 

NOW IN THE FRONT END GIVE THE REFERENCE COLUMN WITH THE ORDER NUMBER AND CTR+F11

Then the following tables effected in the backend

SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE TRX_NUMBER='10068382'-- THIS TABLE CONTAINS THE INFORMATION OF THE SALES ORDER.WITH SALES ORDER NUMBER IN INTERFACE_HEADER_ATTRIBUTE1 COLUMN


SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL WHERE CUSTOMER_TRX_ID='1254197'--THIS TABLE HAS THE INFORMATION OF THE SALES ORDERS INCLUDING THE TAXES OF THE ORDER


SELECT * FROM RA_CUST_TRX_LINE_GL_DIST_ALL WHERE CUSTOMER_TRX_LINE_ID='2007389'--THIS TABLE HAS THE 'EVENT_ID' THIS TABLE HAS THE INFORMATION OF THE GL_CODE_COMBINBATION TO THE WHICH THE AMOUNT HAS TO BE TRANSFERRED 



SELECT SEGMENT1||SEGMENT2||SEGMENT3||SEGMENT4||SEGMENT5 FROM GL_CODE_COMBINATIONS WHERE CODE_COMBINATION_ID=12875

NOW ONCE THE DATA IS IN RECIEVABLES WE NEED TO CREATE ACCOUNTING FOR THE ABOVE SALES ORDERS======================================================================================

SELECT * FROM XLA_EVENTS WHERE EVENT_ID='6229567'--PROCESS_STATUS_CODE='P' THAT MEANS THAT THE ABOVE SALES ORDERS ARE POSTED TO GL

SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID='6229567'--THIS TABLE HAS THE GL_TRANSFER_STATUS_CODE AS 'Y' THAT MEANS THEY ARE TRANSFERED TO GL

SELECT * FROM XLA_AE_LINES WHERE AE_HEADER_ID='8115566'--THIS CONTAINS THE LINES DETAILS WITH TAX INFORMATIOM

=====NAVIGATION==>TOOLS==>CREATING ACCOUNTING==>ACCOUNTING TO GL==>OK THE THE FOLLOWING PROGRAMS RUN IN THE BACKGROUND

NOW CHECK THE GL TABLES=======================

SELECT * FROM GL_JE_BATCHES WHERE NAME LIKE '%Receivables A 3829422 7539160%'-- THIS TABLE HAS THE BATCHE NAME WHICH WE CAN GET FROM THE JOURNAL IMPORT PROGRAM

SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID='5362730'-- THIS TABLE HAS THE JE_BATCH_ID WHICH GIVES THE COMPLETE INFORMATION OF THE RECIEVABLES WJ=ITH JE_SOURCE

SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID='7116873'--THIS TABLE HAS THE LINES INFORMATION OF THE ABOVE TRANSACTIONS FROM AR

NOW WE NEED TO POST THE BALANCES TO GL======================================

SHIFT THE RESPONSIBILITY TO GENERAL LEDGER, IFRS REPORTING VISION OPSTHEN OPEN THE PERIODS IF THEY ARE NOT OPEN BY GOING TO OPEN/CLOSE PERIODS AND THEN POST THE JOURNALS====================================================================================================

effected table in the backend

SELECT * FROM GL_BALANCES WHERE PERIOD_NAME LIKE 'Oct-17%' AND CODE_COMBINATION_ID='12875' ORDER BY LAST_UPDATE_DATE DESC

NOW THE INVOICES HAVE BEEN POSTED NEXT WE NEED TO CREATE THE RECIEPTS FOR THE ABOVE INVOICES============================================================================================CASH RECIEPTS=============SWITCH TO AR RESPONSIBILITY
THEN GO TO RECIEPT AND CREATE ITGIVE THE RECIEPT NUMBER AS ORDER NUMBER AND TRANS NUMBER IS THE NUMBER THAT WE  GET FROM RA_CUSTOMER_TRX_ALL THAT ARE CREAT5ED WHEN WE RUN THE WORKFLOW BACKGROUND PROCESS  'SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE TRX_NUMBER='10068382'' AND PRESS APPLY BUTTON AND SAVE IT ========================================================================================================================================================================================================================================

effected backend tables

SELECT * FROM AR_CASH_RECEIPTS_ALL WHERE RECEIPT_NUMBER='69380'--THIS TABLE GIVES THE INFORMATION OF COMPLETE AMOUNT FOR THR TRANSACTION


SELECT * FROM AR_CASH_RECEIPT_HISTORY_ALL WHERE  CASH_RECEIPT_ID='211296'--THIS TABLE SHOWS THE  COMPLETE INFORMATION OF THE RECIEPT AND IT ALSO HOLDS THE 'EVENT_ID'


SELECT * FROM AR_RECEIVABLE_APPLICATIONS_ALL WHERE CASH_RECEIPT_ID='211296'--THIS TABLE HAS THE COLUMN 'APPLICATION_TYPE' THAT TELLS  TYPE OF PAYMENT MADE. 


SELECT * FROM AR_PAYMENT_SCHEDULES_ALL WHERE CASH_RECEIPT_ID='211296'--THIS TABLE TELLS THE THAT HAS BEEN PAID AND TELLS IF WE HAVE ANY REMAINING OR FORWARD BALANCE THAT WE HAVE TO PAY.

NOW AGAIN CREATE THE ACCOUNTING FOR THE ABOVE RECIEPTS CREATED ==============================================================

NOW GOTO RECIEVABLES RESPONSIBILLITY AND GOTO RECIEPTS==>RECIEPTS AND QUERY FOR THE RECIEPT NUMBER AND GO TO TOOLS==>CREATE ACCOUNTING==>CREATE FINAL ACCOUNTING POST TO GL

EFFECTED TABLES:


SELECT * FROM XLA_EVENTS WHERE EVENT_ID='6229568'--PROCESS_STATUS_CODE='P' THAT MEANS THAT THE ABOVE SALES ORDERS ARE POSTED TO GL


SELECT * FROM XLA_AE_HEADERS WHERE EVENT_ID='6229568'-- THIHS TABLE TELLS THE EVENT_TYPE_CODE


SELECT * FROM XLA_AE_LINES WHERE AE_HEADER_ID='8115567'--THIS CONTAINS THE LINES DETAILS 

NOW THE DATA HAS ALSO BEEN TRANSFERED TO GL===========================================

SELECT * FROM GL_JE_BATCHES WHERE NAME LIKE 'Receivables A 3829423 7539176%'-- THIS TABLE HAS THE BATCHE NAME WHICH WE CAN GET FROM THE JOURNAL IMPORT PROGRAM 

SELECT * FROM GL_JE_HEADERS WHERE JE_BATCH_ID=5362733---THIS TABLE HAS THE JE_BATCH_ID WHICH GIVES THE COMPLETE INFORMATION OF THE RECIEVABLES WJ=ITH JE_SOURCE

SELECT * FROM GL_JE_LINES WHERE JE_HEADER_ID=7116876--THIS TABLE HAS THE LINES INFORMATION OF THE ABOVE TRANSACTIONS FROM AR

NOW WE HAVE TO POST THE BALANCES TO GL======================================

NOW SHIFT THE RESPONSIBILITY TO  GENERAL LEDGER, IFRS REPORTING VISION OPSTHEN OPEN THE PERIODS IF THEY ARE NOT OPEN BY GOING TO OPEN/CLOSE PERIODS AND THEN POST THE JOURNALS====================================================================================================

Effected tables:

SELECT * FROM GL_BALANCES   WHERE PERIOD_NAME LIKE 'Oct-17%' AND CODE_COMBINATION_ID='12875'