DBA Data[Home] [Help]

APPS.INV_LABEL_PVT4 dependencies on RCV_SHIPMENT_HEADERS

Line 134: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,

130: hrl1.location_code deliver_to_location,
131: hrl2.location_code location, pll.note_to_receiver note_to_receiver
132: FROM rcv_transactions_interface rti, po_headers_all pha,
133: -- MOAC : po_line_locations changed to po_line_locations_all
134: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
135: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
136: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
137: po_vendor_sites_all pvs, per_people_f ppf
138: where rti.interface_transaction_id = p_transaction_id

Line 166: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,

162: hrl1.location_code deliver_to_location,
163: hrl2.location_code location, pll.note_to_receiver note_to_receiver
164: FROM rcv_transactions_interface rti, po_headers_all pha,
165: -- MOAC : po_line_locations changed to po_line_locations_all
166: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
167: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
168: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
169: po_vendor_sites_all pvs, per_people_f ppf
170: where rti.interface_transaction_id = p_transaction_id

Line 359: , rcv_shipment_headers rsh

355: )
356: ) all_lpn
357: , po_headers_all pha
358: , po_lines_all pol
359: , rcv_shipment_headers rsh
360: , rcv_shipment_lines rsl
361: -- MOAC : po_line_locations changed to po_line_locations_all
362: , po_line_locations_all pll
363: , po_vendors pov

Line 937: rcv_shipment_headers rsh,

933: , rsl.COUNTRY_OF_ORIGIN_CODE
934: , rsl.comments
935: , rsl.vendor_item_num
936: from wms_license_plate_numbers lpn,
937: rcv_shipment_headers rsh,
938: rcv_shipment_lines rsl
939: where lpn.source_name = rsh.shipment_num
940: AND lpn.lpn_context = 7
941: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 959: rcv_shipment_headers rsh,

955: , rsl.COUNTRY_OF_ORIGIN_CODE
956: , rsl.comments
957: , rsl.vendor_item_num
958: from wms_license_plate_numbers lpn,
959: rcv_shipment_headers rsh,
960: rcv_shipment_lines rsl
961: where lpn.source_name = rsh.shipment_num
962: AND lpn.lpn_context = 7
963: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 981: rcv_shipment_headers rsh,

977: , rsl.COUNTRY_OF_ORIGIN_CODE
978: , rsl.comments
979: , rsl.vendor_item_num
980: from wms_license_plate_numbers lpn,
981: rcv_shipment_headers rsh,
982: rcv_shipment_lines rsl
983: where lpn.source_name = rsh.shipment_num
984: AND lpn.lpn_context = 7
985: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 992: , rcv_shipment_headers rsh

988: AND rsh.asn_type = 'ASN'
989: ) all_lpn
990: , po_headers_all pha
991: , po_lines_all pol
992: , rcv_shipment_headers rsh
993: -- MOAC : po_line_locations changed to po_line_locations_all
994: , po_line_locations_all pll
995: , po_vendors pov
996: , hr_locations_all hrl1

Line 1443: FROM rcv_shipment_headers

1439: l_rcv_isp_header.bill_of_lading, l_rcv_isp_header.waybill_airbill_num,
1440: l_rcv_isp_header.packing_slip,
1441: l_rcv_isp_header.packaging_code, l_rcv_isp_header.special_handling_code,
1442: l_rcv_isp_header.receipt_num,l_rcv_isp_header.comments
1443: FROM rcv_shipment_headers
1444: WHERE shipment_header_id = p_transaction_id;
1445:
1446: -- Next retrieve details of all distinct LPNs associated with this shipment
1447: FOR v_asn_lpn IN c_asn_lpn