DBA Data[Home] [Help]

APPS.INV_LABEL_PVT3 dependencies on RCV_SHIPMENT_LINES

Line 402: rcv_shipment_lines rsl

398: , rsh.shipment_header_id
399: , rsl.po_line_location_id
400: from wms_license_plate_numbers lpn,
401: rcv_shipment_headers rsh,
402: rcv_shipment_lines rsl
403: where lpn.source_name = rsh.shipment_num
404: AND lpn.lpn_context = 7
405: AND rsl.shipment_header_id = rsh.shipment_header_id
406: and rsh.shipment_header_id = p_transaction_id

Line 417: rcv_shipment_lines rsl

413: , rsh.shipment_header_id
414: , rsl.po_line_location_id
415: from wms_license_plate_numbers lpn,
416: rcv_shipment_headers rsh,
417: rcv_shipment_lines rsl
418: where lpn.source_name = rsh.shipment_num
419: AND lpn.lpn_context = 7
420: AND rsl.shipment_header_id = rsh.shipment_header_id
421: and rsl.asn_lpn_id = lpn.lpn_id

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