Get Even More Visitors To Your Blog, Upgrade To A Business Listing >>

Oracle APPS Purchasing : PO and Requisitions Technical Aspects

Link from PO to Requisition: Table with related column: 
PO_DISTRIBUTIONS_ALL.REQ_DISTRIBUTION_ID(Requisition Distribution unique identifier) 

If you autocreate this accounting distribution from a requisition, REQ_DISTRIBUTION_ID corresponds to the ID of the requisition distribution you copy on the Purchase order. 


Link from Requisition to PO: PO_REQUISITION_LINES_ALL.LINE_LOCATION_ID(Document shipment schedule unique identifier ) 

LINE_LOCATION_ID identifies the purchase order shipment line on which you placed the requisition. LINE_LOCATION_ID is null if you have not placed the requisition line on a purchase order. 
BLANKET_PO_HEADER_ID and BLANKET_PO_LINE_NUM store the suggested blanket purchase agreement or catalog quotation line information for the requisition line. 

For Purchase Order: PO_LINE_LOCATIONS_ALL table has LINE_LOCATION_ID column.

This post first appeared on EBiz Integration Technics, please read the originial post: here

Share the post

Oracle APPS Purchasing : PO and Requisitions Technical Aspects


Subscribe to Ebiz Integration Technics

Get updates delivered right to your inbox!

Thank you for your subscription