DBA Data[Home] [Help]

APPS.INV_LABEL_PVT3 dependencies on RCV_SHIPMENT_LINES

Line 432: rcv_shipment_lines rsl

428: , rsh.shipment_header_id
429: , rsl.po_line_location_id
430: from wms_license_plate_numbers lpn,
431: rcv_shipment_headers rsh,
432: rcv_shipment_lines rsl
433: where lpn.source_name = rsh.shipment_num
434: AND lpn.lpn_context = 7
435: AND rsl.shipment_header_id = rsh.shipment_header_id
436: and rsh.shipment_header_id = p_transaction_id

Line 447: rcv_shipment_lines rsl

443: , rsh.shipment_header_id
444: , rsl.po_line_location_id
445: from wms_license_plate_numbers lpn,
446: rcv_shipment_headers rsh,
447: rcv_shipment_lines rsl
448: where lpn.source_name = rsh.shipment_num
449: AND lpn.lpn_context = 7
450: AND rsl.shipment_header_id = rsh.shipment_header_id
451: and rsl.asn_lpn_id = lpn.lpn_id

Line 462: rcv_shipment_lines rsl

458: , rsh.shipment_header_id
459: , rsl.po_line_location_id
460: from wms_license_plate_numbers lpn,
461: rcv_shipment_headers rsh,
462: rcv_shipment_lines rsl
463: where lpn.source_name = rsh.shipment_num
464: AND lpn.lpn_context = 7
465: AND rsl.shipment_header_id = rsh.shipment_header_id
466: and rsh.shipment_header_id = p_transaction_id