Tuesday, March 9, 2010
R12: Tables involved in Purchasing Module - Receiving
Query which links important Receiving tables along with their important columns listed,
select rcvt.transaction_id
,rcvt.transaction_type
,rcvt.po_distribution_id
,rcvt.po_header_id
,rcvt.po_line_id
,rcvt.po_line_location_id
,rcvt.po_release_id
,rcvt.transaction_date
,rcvl.quantity_shipped
,rcvl.quantity_received
,rcvl.item_description
,rcvl.item_id
,rcvl.shipment_line_status_code
,rcvl.destination_type_code
,rcvl.to_subinventory
,rcvh.shipment_header_id
,rcvh.receipt_num
,rcvh.receipt_source_code
,rcvh.vendor_id
,rcvh.vendor_site_id
from rcv_shipment_headers rcvh
,rcv_shipment_lines rcvl
,rcv_transactions rcvt
where 1 = 1
AND rcvh.shipment_header_id = rcvl.shipment_header_id
AND rcvl.shipment_line_id = rcvt.shipment_line_id
AND rcvh.shipment_header_id = rcvt.shipment_header_id
AND rcvt.transaction_type = 'RECEIVE'
AND rcvt.po_header_id = ‘&po_header_id'
Do you think this Article is useful?
Subscribe to:
Post Comments (Atom)
0 Responses to “R12: Tables involved in Purchasing Module - Receiving”
Post a Comment