DBA Data[Home] [Help]

APPS.WMS_PACKING_WORKBENCH_PVT dependencies on PO_LINE_LOCATIONS_ALL

Line 1512: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll

1508: BEGIN
1509: SELECT poh.po_header_id, poh.segment1, pol.po_line_id, pol.line_num
1510: INTO l_material_rec.document_id, l_material_rec.document_number
1511: , l_material_rec.document_line_id, l_material_rec.document_line_num
1512: FROM po_headers_all poh, po_lines_all pol, po_line_locations_all poll
1513: WHERE poll.line_location_id = l_material_rec.reference_id
1514: AND poh.po_header_id = poll.po_header_id
1515: AND pol.po_line_id = poll.po_line_id;
1516: EXCEPTION

Line 1532: FROM po_lines_all pol, po_line_locations_all poll

1528: IF (l_material_rec.reference_id IS NOT NULL) THEN
1529: BEGIN
1530: SELECT pol.po_line_id, pol.line_num
1531: INTO l_material_rec.document_line_id, l_material_rec.document_line_num
1532: FROM po_lines_all pol, po_line_locations_all poll
1533: WHERE poll.line_location_id = l_material_rec.reference_id
1534: AND pol.po_line_id = poll.po_line_id;
1535: EXCEPTION
1536: WHEN no_data_found THEN