APPS.PO_DOCUMENT_CONTROL_GRP dependencies on PO_LINE_LOCATIONS

Line 1035: FROM po_line_locations poll

1031:
1032: IF (p_doc_line_loc_id IS NULL) THEN
1033: SELECT poll.line_location_id
1034: INTO x_doc_line_loc_id
1035: FROM po_line_locations poll
1036: WHERE poll.shipment_num = p_doc_shipment_num AND
1037: poll.po_line_id = x_doc_line_id AND
1038: poll.po_header_id = x_doc_id;
1039: ELSE

Line 1042: FROM po_line_locations poll

1038: poll.po_header_id = x_doc_id;
1039: ELSE
1040: SELECT 'Exists'
1041: INTO l_exists
1042: FROM po_line_locations poll
1043: WHERE poll.line_location_id = x_doc_line_loc_id AND
1044: poll.po_line_id = x_doc_line_id AND
1045: poll.po_header_id = x_doc_id;
1046: END IF; --

Line 1229: FROM po_line_locations poll,

1225: -- SQL Why: Need to derive the missing unique line_location_id
1226: -- SQL Join: po_line_id
1227: SELECT poll.line_location_id
1228: INTO x_doc_line_loc_id
1229: FROM po_line_locations poll,
1230: po_lines pol
1231: WHERE poll.po_release_id = x_doc_id AND
1232: poll.po_header_id = l_release_po_header_id AND
1233: poll.po_line_id = pol.po_line_id AND

Line 1239: FROM po_line_locations poll

1235: pol.po_header_id = l_release_po_header_id;
1236: ELSE
1237: SELECT 'Exists'
1238: INTO l_exists
1239: FROM po_line_locations poll
1240: WHERE poll.line_location_id = x_doc_line_loc_id AND
1241: poll.po_release_id = x_doc_id;
1242: END IF; --
1243: