link between po and receipt in oracle apps

link between po and receipt in oracle apps

Here below , you will find the table/db links between PO and receipts modules in Oracle Apps. I will share the tables involved between this link. Here you will also find the sql query also to fetch the data between the PO and receipt module using link between po and receipt in oracle apps.

 

Tables Involved

 

rcv_shipment_lines

rcv_shipment_headers

rcv_transactions

 

po_headers_all

po_lines_all

po_distributions_all

po_line_locations_all

 

select PO_HEADER_ID,PO_LINE_ID,PO_LINE_LOCATION_ID from apps.rcv_shipment_lines

 

select PO_HEADER_ID,PO_LINE_ID from po_lines_all

 

select Po_header_id,segment1 po_number from po_headers_all

 

 

sql queries showing link between po and receipt in oracle apps

select a4.segment1 po_number,RECEIPT_NUM,a2.ITEM_DESCRIPTION,a2.UNIT_OF_MEASURE,a2.QUANTITY_SHIPPED,a2.QUANTITY_RECEIVED from rcv_shipment_headers a1,rcv_shipment_lines a2,po_lines_all a3,po_headers_all a4

where RECEIPT_NUM=:P_RECEIPT_NUM

and a1.shipment_header_id=a2.shipment_header_id

and a2.PO_HEADER_ID=a3.PO_HEADER_ID

and a2.PO_LINE_ID=a3.PO_LINE_ID

and a3.PO_HEADER_ID=a4.PO_HEADER_ID