O2C COMPLETE CYCLE WITH TABLES

ORDER MANAGEMENT:
==================


ITEMS
CUSTOMER
SALESREP

TO CREATE ITEM GO TO INVENTORY RESP

->MASTER ITEMS ->ITEMS.
THEN ->INVENTORY.
THEN ->PURCHASE-> CHECK PURCHASABLE.
THE ->ORDER MANAGEMENT -> CHECK CUSTOMER ORDERED
                          CHECK INTERNAL ORDERED
                          CHECK RETURNABLE
                          CHECK RMA INSPECTION REQUIRED
                          CHECK FINANCING ALLOWED.

THEN ->INVOICING -> CHECK INVOICABLE ITEM.


TRANSACTIONS -> MISCELLINEOUS TRANSACTIONS ->TYPE:MISCELLINEOUS RECEIPT.

INVENTORY TABLES:
==================


SELECT * FROM MTL_SYSTEM_ITEMS_B MSIB WHERE MSIB.SEGMENT1='SIM_CUTTER'--IT HAS COMPOSITE PK.

HERE IT SHOWS DUPLICATE BECAUSE I ASSIGNED THIS ITEM FOR 2 ORGANIZATIONS.


INVENTORY_ITEM_ID=21795 AND ORGANIZATION_ID=204

TO FIND ONHAND QUANTITY:
========================

SELECT * FROM  MTL_ONHAND_QUANTITIES WHERE INVENTORY_ITEM_ID=21795 AND ORGANIZATION_ID=204

TO KNOW TRANSACTION_TYPES:
===========================

SELECT * FROM MTL_TRANSACTION_TYPES  WHERE TRANSACTION_TYPE_ID=52

ANY MATERIAL TRANSACTION:
=========================

SELECT * FROM MTL_MATERIAL_TRANSACTIONS WHERE INVENTORY_ITEM_ID=21795 AND ORGANIZATION_ID=204

OR

SELECT * FROM MTL_MATERIAL_TRANSACTIONS WHERE PICK_SLIP_NUMBER=146338--TRANSACTION_ID IS PK.


SELECT * FROM WSH_DELIVERY_DETAILS

SELECT WND.SOURCE_HEADER_ID,WND.* FROM WSH_NEW_DELIVERIES WND WHERE WND.SOURCE_HEADER_ID=190434

SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_ID=3777372




CUSTOMER CREATION:
=====================

GO TO ORDER MANAGEMENT SUPER USER,VISION OPERATIONS(USA).

NAVIGATION:
-=============

->CUSTOMERS ->STANDARD -> CUSTOMER TYPE: ORGANIZATION ->PRESS CREATE(BUTTON) -> ENTER THE DETAILS. ->APPLY(BUTTON).

IN AR MODULE TCA IS IMPLEMENTED.

TCA(TRADING COMMUNITY ARCHITECTURE.):
=====================================

TCA IS DATA MODEL WHICH WILL COMBINE  ALL THE TRADING PARTNER DETAILS LIKE CUSTOMER,BANK,EMPLOYEE,SUPPLIERS.

HERE CUSTOMER IS NOTHING BUT PARTY


CUSTOMER TABLES:
===================

SELECT * FROM HZ_PARTIES WHERE PARTY_NAME='JM_ORACLE_INSTITUTE'--PARTY_ID IS PK.

SELECT * FROM HZ_PARTY_SITES WHERE PARTY_ID=411679--PARTY_SITE_ID IS PK.

SELECT * FROM HZ_CUST_ACCOUNTS WHERE PARTY_ID=411679--CUST_ACCOUNT_ID IS PK.

SELECT * FROM HZ_CONTACT_POINTS -- CONTACT_POINT_ID IS PK.

SELECT * FROM HZ_LOCATIONS-- LOCATION_ID IS PK.

SELECT * FROM HZ_CUST_PROFILE_CLASSES -- PROFILE_CLASS_ID IS PK.

SELECT * FROM HZ_CUST_SITE_USES_ALL --SITE_USE_ID IS PK.


SALES REP:
==========

SELECT * FROM RA_SALESREPS_ALL--SALESREP_ID IS PK.

HERE HZ MEANS HUMAN ZONE.



TO CREATE SALES ORDER:
========================

GO TO ORDER MANAGEMENT SUPER USER VISION OPERATIONS (USA)


SALES ORDER TYPES:
==================

8 TYPES.

1.STANDARD
2.MIXED
3. QUOTATION
4.BACK ORDER
5. ISO INTERNAL SALES ORDER
6.BACK TO BACKORDERS
7.DROP SHIPMENT
8.RMA-CREDIT



NAVIGATION:
===========

->ORDERS,RETURNS ->SALES ORDERS ->ENETER THE DETAILS AT "MAIN" TAB.
-> ENTER THE DETAILS AT "OTHERS" TAB. AND MOVE TO "LINES" TAB. AND ENTER THE DETAILS.

->PRESS "BOOK ORDER" BUTTON.


COPY THE ORDER NUMBER.




SALES ORDER TABLES:
===================

SELECT OOHA.FLOW_STATUS_CODE,OOHA.*  FROM OE_ORDER_HEADERS_ALL OOHA WHERE OOHA.ORDER_NUMBER=66413--HEADER_ID IS PK.

SELECT OOLA.FLOW_STATUS_CODE,OOLA.* FROM OE_ORDER_LINES_ALL OOLA WHERE OOLA.HEADER_ID=190432--LINE_ID IS PK.

COLUMN "FLOW_STATUS_CODE" IT WILL SHOW THE STATUS OF THE SALES ORDER.


SELECT WDD.RELEASED_STATUS,WDD.* FROM WSH_DELIVERY_DETAILS WDD WHERE WDD.SOURCE_HEADER_ID=190432

RELEASED STATUS-> R-READY TO RELEASE
                  S-RELEASED TO WARE HOUSE.
                  Y-PICK CONFIRMED.
                  C-SHIP CONFIRMED.
               


SELECT * FROM MTL_RESERVATIONS WHERE INVENTORY_ITEM_ID=21795 AND ORGANIZATION_ID=204

SELECT * FROM WSH_DELIVERY_ASSIGNMENTS WHERE DELIVERY_ID=3777372



BATCH(IN RELEASES) 3914028 IN RELEASE FORM.
OR
"PICK BATCH" IN  "PICK SLIP REPORT" OUTPUT FILE IN SRS WINDOW
OR

"MOVE ORDER" IN  "PICK SLIP REPORT" OUTPUT FILE IN SRS WINDOW



TO RELEASE ITEMS:
===================

->SHIPPIING -> RELEASES SALES ORDERS ->RELEASE SALES ORDERS.->ENTER THE DETAILS.

WHEN WE DO RELEASE THE ITEMS IN BACKGROUND 3 PGMS WILL RUN IN THE SRS WINDOW.

1.Pick Selection List Generation
2.PICK SLIP REPORT
3.Shipping Exceptions Report

MOVE ORDER TABLES:
===================

WE WILL SEE OFTER RELEASES STEP.

HEADERS:
========

WHERE REQUEST_NUMBER IS NOTHING BUT "MOVE ORDER" OR "PICK BATCH" IN PICK SLIP REPORT OUTPUT FILE IN SRS WINDOW.


SELECT * FROM MTL_TXN_REQUEST_HEADERS WHERE REQUEST_NUMBER='3914028'--HEADER_ID IS PK.

LINES:
======

SELECT * FROM MTL_TXN_REQUEST_LINES WHERE HEADER_ID='3914029'

HERE U CAN SEE THE ITEMS MOVED FROM WHERE TO WHERE.
BY USING THE COLUMNS "FROM_SUBINVENTORY_CODE" AND "TO_SUBINVENTORY_CODE"

TRANSACTION_TYPE_ID=52


SELECT * FROM MTL_TRANSACTION_TYPES WHERE TRANSACTION_TYPE_ID=52

HERE WE CAN FIND OUT THE TRANSACTION TYPE IN "TRANSACTION_TYPE_NAME" COLUMN.


SO TRANSACTION_TYPE_ID=52 IS 'Sales Order Pick'


SELECT * FROM MTL_MATERIAL_TRANSACTIONS WHERE PICK_SLIP_NUMBER=146338--TRANSACTION_ID IS PK.

WE CAN GET THE "PICK_SLIP_NUMBER" IN "PICL SLIP REPORT" AS A "Pick Slip:146338 ".


SELECT * FROM MTL_ONHAND_QUANTITIES WHERE INVENTORY_ITEM_ID=21795 AND ORGANIZATION_ID=204


TO SHIP ITEMS:
=================

COPY ORDER NUMBER AND GOT TO
->SHIPPING ->TRANSACTIONS ->ENTER THE DETAILS. ->ORDER NUMBER: CTRL+V ->FIND ->THEN

GO TO DELIVERY TAB ->PRESS "SHIP CONFIRM"(BUTTON) ->OK ->OK.

WHEN WE DO THE SHIPPIING IN BACKGROUND 5 PGMS WILL RUN WE CAN FIND THESE IN SRS WINDOW.

1.Bill of Lading:CONTAINIG THE ORGANIZATION LICENSE INFORMATION.

2.Packing Slip Report:HOW THE MATERIAL ARE PACKED. LIFO/FILO.

3.Commercial Invoice: INVOICE WITH OUT TAX DETAILS ONLY PRODUCT COST WILL BE SPECIFIED.

4.Vehicle Load Sheet Details:HOW THE ITEMS ARE LOADED IN THE VEHICLE

5.Interface Trip Stop: INTERFACE DATA TRANSFER TO AR MODULE.


->GO TO SRS WINDOW->RUN "WORK FLOW BACKGROUND PROCESS"
PREDEFINED:YES
PROCESS TIMEOUT :YES
PROCESS STUCK:YES

THIS WORK FLOW BACKGROUND PROCESS WILL EXECUTE THE AUTO INVOICE PROGRAMM.


AFTER RUNNING THE WORKFLOW BACKGROUND PROCESS PGM. WE CAN FIND THE INVOICE NUMBER IN ->ORDERS,RETURNS
->ORDER ORGANIZER ->PASS ORDER NUMBER ->PRESS "FIND"(BUTTON) ->ACTIONS(BUTTON) ->ADDITONAL INFORMATION
->INVOICES / CREDIT MEMOS ->COPY VALUE IN "NUMBER"(INVOICE NUMBER) FIELD.



SELECT * FROM RA_INTERFACE_LINES_ALL

SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE INTERFACE_HEADER_ATTRIBUTE1='66413'--CUSTOMER_TRX_ID IS PK.

(OR)

SELECT * FROM RA_CUSTOMER_TRX_ALL WHERE TRX_NUMBER='10037602' AND ORG_ID=204

->TRX_NUMBER IS INDIRECTLY INVOICE NUMBER.

-> WE CAN HAVE DUPLICATE INVOICE_NUMBERS FOR DIFFERENT ORGANIZATIONS.


->IN ABOVE TABLE "INTERFACE_HEADER_ATTRIBUTE1" IS NOTHING BUT "ORDER_NUMBER" IN OE_ORDER_HEADERS_ALL.

->IN ABOVE TABLE, COLUMN "TRX_NUMBER" IS NOTHING BUT INVOICE_NUMBER.


LINES TABLE:
=============

SELECT * FROM RA_CUSTOMER_TRX_LINES_ALL WHERE CUSTOMER_TRX_ID=757204

SELECT * FROM RA_CUST_TRX_LINE_GL_DIST_ALL WHERE CUSTOMER_TRX_ID=757204

SELECT * FROM RA_CUST_TRX_TYPES_ALL WHERE CUST_TRX_TYPE_ID=1361



THE DUE DATE AND PAYMENT TERMS WE CAN FIND IN "AR_PAYMENT_SCHEDULES_ALL" TABLE.
================================================================================


SELECT * FROM AR_PAYMENT_SCHEDULES_ALL  WHERE CUSTOMER_TRX_ID=757204--PAYMENT_SCHEDULE_ID IS PK.

(OR)

SELECT * FROM AR_PAYMENT_SCHEDULES_ALL WHERE TRX_NUMBER='10037602' AND ORG_ID=204



SELECT * FROM OE_TRANSACTION_TYPES_ALL WHERE TRANSACTION_TYPE_ID=1456





GO TO RECEIVABLES,VISION OPERATIONS(USA):
==========================================

TO QUERY INVOICE :
=================

GO TO TRANSACTIONS ->TRANSACTIONS ->F11 ->PASTE TRX_NUMBER IN "NUMBER" FIELD ->CTRL+F11
-> SELECT TOOLS IN HORIZONTAL TOOL BAR ->CREATE ACCOUNTING ->FINAL POST TO GL.


TO CREATE INVOICE MANUALLY:
============================.

NAVIGATIONS:
=============

GO TO TRANSACTIONS ->TRANSACTIONS ->ENTER THE DETAILS ->GIVE ORDER_NUMBER IN "REFERENCE" FILED ->ENTER LINES DATA

-> ENTER DISTRIBUTIONS DATA. ->CTRL+S -> GOT TO "TOOLS" MENU IN HORIZONTAL TOOL BAR.
->CREATE ACCOUNTING ->FINAL POST TO GL.

TO CREATE RECEIPT:
==================

GO TO RECEIVABLES VISION OPERATIONS(USA)


NAVIGATION:
===========

->RECEIPTS ->RECEIPTS ->ENTER THE DETAILS ->APPLY(BUTTON).


SELECT * FROM AR_CASH_RECEIPTS_ALL WHERE RECEIPT_NUMBER='REC3'--CASH_RECEIPT_ID IS PK.

CASH_RECEIPT_ID=110051

REMITTANCE:
==============

RECEIPTS ->REMITTANCES ->ENTER THE DETAILS ->PRESS "MANUAL CREATE" -> PRESS F11 THEN PLACE THE
CURSOR IN "NUMBER" FILED ->ENTER RECEIPT NUMBER ->CTRL+F11.
-> CHECK THE CHECK BOX AT LINES LEVEL(THAT MEANS LEFT SIDE OF THE RECEIPT NUMBER).
->PRESS "FORMAT"(BUTTON).->YES ->OK ->OK ->OK.THEN CLOSE THE REMITTANCE FORM.

->OPEN RECEIPTS FORM ->F11->PLACE THE CURSON IN "RECEIPT NUMBER" FIELD ->ENTER THE REEIPT NUMBER ->CTRL+F11.

->SEE THE "STATUS" FIELD.
->THEN CLOSE THE FORM.




GO TO CASH MANAGEMENT VISION OPERATIONS (USA):
==============================================

NAVIGATIONS:
=============

->BANK STATEMENTS ->MANUAL CLEARING ->CLEAR TRANSACTIONS ->ACCOUNT NAME: BOFA-204->FIND ->F11 ->PLACE THE CURSOR IN
"NUMBER" FIELD ->ENTER RECEIPT NUMBER ->CTRL+F11.

-> CHECK THE CHECK BOX AT LEFT SIDE OF THE NUMBER FILED. ->PRESS "CLEAR TRANSACTION"(BUTTON). ->CLOSE FORM.

->SWITCH TO RECEIVABLES VISION OPERATIONS USER (USA)

RECEIPTS ->RECEIPTS ->F11 -> ENTER RECEIPT NUMBER ->CTRL+F11.

->SEE THE "STATUS" FIELD.

->"TOOLS" MENU IN HORIZONTAL TOOL BAR ->CREATE ACCOUNTING ->CREATE FINAL ACCOUNTING.

->"TOOLS" MENU IN HORIZONTAL TOOL BAR ->VIEW ACCOUNTING.->CLOSE WINDOW.

->THEN GO TO SRS WINDOW.->SUBMIT A NEW REQUEST ->SINGLE REQUEST ->OK

->IN "NAME" FIELD. SELECT "TRANSFER JOURNAL ENTRIES TO GL"

PARAMETERS:
==========

LEDGER: VISION OPERATIONS (USA)
END DATE:31-OCT-2014
POST IN GENERAL LEDGER: NO

->OK.

->FIND.



GO TO GENERAL LEDGER VISION OPERATIONS(USA):
===============================================

JOURNALS ->ENTER -> COPY REQUEST NUMBER OF "JOURNAL IMPORT" FROM SRS WINDOW. ->BATCH: %6009780% ->FIND.


SEE THE BATCH_STATUS.

->REVIEW JOURNAL ->CLOSE FORM ->PRESS POST (IT WILL RUN CONCURRENT PGM) ->REQUERY. ->SEMILARLY FOR ALL LINES.


SELECT * FROM GL_INTERFACE

--JOURNAL IMPORT.

SELECT * FROM GL_JE_HEADERS

SELECT * FROM GL_JE_LINES

SELECT * FROM GL_JE_BATCHES


--POSTING

SELECT * FROM GL_BALANCES

BEFORE POSTING WE CAN CANCEL/REVERSE/MODIFY.

AFTER POSTING WE CAN NOT MAKE ANY CHANGES.


TABLES:
=========

SELECT * FROM RA_SALESREPS_ALL

REQUIREMENT:
============

SELECT
FROM
WHERE 1=1