Procure To Pay Cycle with Tables joins

1) Create Requisition:
Requisition is nothing but a formal request to buy something (like Inventory material, office supplies etc) needed for the enterprise. Only an employee can create one. There are two types of requisitions:
Internal Requisition: Internal requisitions provide the mechanism for requesting and transferring material from one inventory to other inventory.
Purchase requisition: Unlike Internal requisitions, Purchase requisitions are used for requesting material from suppliers.
Once the requistion is created, the status of the requisition will be “Incomplete”. And now the Approve button is highlighted. The requisition needs to be approved first before proceeding further by the concerned authority. Submit this requisition for Approval by clicking on the Approve button. The status will now be updated to “In Process”. The workflow then will send an Approval notification to the concerned person (derived based on hierarchy used - Position or Supervisor hierarchy) using which he can Approve or Reject the requisition.

Tables  - 

 PO_REQUISITION_HEADERS_ALL
 PO_REQUISITION_LINES_ALL 
 PO_REQ_DISTRIBUTIONS_ALL

Requisition_header_id is the link between PO_REQUISITION_HEADERS_ALL and PO_REQUISITION_LINES_ALL tables.

Requisition_line_id is the link between PO_REQUISITION_LINES_ALL and  PO_REQ_DISTRIBUTIONS_ALL tables.

2) Create Purchase Order:

Create Purchase order  by entering Header, Line and Shipment details. There can be multiple distributions for each shipment. Requisition Number is entered in More tab of Shipment Distributions window

Underlying Tables:

PO_HEADERS_ALL

PO_LINES_ALL
PO_LINE_LOCATIONS_ALL
PO_DISTRIBUTIONS_ALL

PO_header_id is link between PO_HEADERS_ALL and PO_LINES_ALL tables.

PO_line_id is link between PO_LINES_ALL and PO_LINE_LOCATIONS_ALL tables.

PO_header_id and PO_line_id both are available into PO_LINE_LOCATIONS_ALL

Distribution_id  (PO_REQ_DISTRIBUTION_ALL)  and po_distribution_id (PO_DISTRIBUTIONS_ALL) are joined in requisition and purchase order tables.