APPS.INV_LABEL_PVT5 dependencies on RCV_SHIPMENT_HEADERS

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

202: ppf.full_name requestor, hrl1.location_code deliver_to_location,
203: hrl2.location_code location, pll.note_to_receiver note_to_receiver
204: FROM rcv_transactions_interface rti, po_headers_all pha,
205: -- MOAC : changed po_line_locations to po_line_locations_all
206: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
207: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
208: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
209: po_vendor_sites_all pvs, per_people_f ppf
210: where rti.interface_transaction_id = p_transaction_id

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

234: hrl1.location_code deliver_to_location, hrl2.location_code location,
235: pll.note_to_receiver note_to_receiver
236: FROM rcv_transactions_interface rti, po_headers_all pha,
237: -- MOAC : changed po_line_locations to po_line_locations_all
238: po_lines_all pol, rcv_shipment_headers rsh, po_line_locations_all pll,
239: po_vendors pov, hr_locations_all hrl1, hr_locations_all hrl2,
240: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
241: po_vendor_sites_all pvs, per_people_f ppf
242: where rti.interface_transaction_id = p_transaction_id

Line 424: , rcv_shipment_headers rsh

420: )
421: ) all_lpn
422: , po_headers_all pha
423: , po_lines_all pol
424: , rcv_shipment_headers rsh
425: , rcv_shipment_lines rsl
426: -- MOAC : changed po_line_locations to po_line_locations_all
427: , po_line_locations_all pll
428: , po_vendors pov

Line 621: rcv_shipment_headers rsh,

617: , rsl.COUNTRY_OF_ORIGIN_CODE
618: , rsl.comments
619: , rsl.vendor_item_num
620: from wms_license_plate_numbers lpn,
621: rcv_shipment_headers rsh,
622: rcv_shipment_lines rsl
623: where lpn.source_name = rsh.shipment_num
624: AND lpn.lpn_context = 7
625: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 643: rcv_shipment_headers rsh,

639: , rsl.COUNTRY_OF_ORIGIN_CODE
640: , rsl.comments
641: , rsl.vendor_item_num
642: from wms_license_plate_numbers lpn,
643: rcv_shipment_headers rsh,
644: rcv_shipment_lines rsl
645: where lpn.source_name = rsh.shipment_num
646: AND lpn.lpn_context = 7
647: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 665: rcv_shipment_headers rsh,

661: , rsl.COUNTRY_OF_ORIGIN_CODE
662: , rsl.comments
663: , rsl.vendor_item_num
664: from wms_license_plate_numbers lpn,
665: rcv_shipment_headers rsh,
666: rcv_shipment_lines rsl
667: where lpn.source_name = rsh.shipment_num
668: AND lpn.lpn_context = 7
669: AND rsl.shipment_header_id = rsh.shipment_header_id

Line 676: , rcv_shipment_headers rsh

672: AND rsh.asn_type = 'ASN'
673: ) all_lpn
674: , po_headers_all pha
675: , po_lines_all pol
676: , rcv_shipment_headers rsh
677: -- MOAC : changed po_line_locations to po_line_locations_all
678: , po_line_locations_all pll
679: , po_vendors pov
680: , hr_locations_all hrl1

Line 1498: FROM rcv_shipment_headers

1494: l_rcv_isp_header.bill_of_lading, l_rcv_isp_header.waybill_airbill_num,
1495: l_rcv_isp_header.packing_slip,
1496: l_rcv_isp_header.packaging_code, l_rcv_isp_header.special_handling_code,
1497: l_rcv_isp_header.receipt_num, l_rcv_isp_header.comments
1498: FROM rcv_shipment_headers
1499: WHERE shipment_header_id = p_transaction_id
1500: -- OR shipment_header_id in --Bug 5051210. Performance fix. Removing OR and adding UNION
1501: UNION
1502: SELECT shipment_num asn_num, shipped_date shipment_date,

Line 1509: FROM rcv_shipment_headers

1505: bill_of_lading, waybill_airbill_num,
1506: packing_slip,
1507: packaging_code, special_handling_code,
1508: receipt_num, comments
1509: FROM rcv_shipment_headers
1510: WHERE shipment_header_id IN
1511: (select shipment_header_id from rcv_shipment_lines
1512: where asn_lpn_id = p_lpn_id);
1513: