APPS.PO_DOCUMENT_CONTROL_GRP dependencies on PO_LINE_LOCATIONS

Line 638: FROM po_line_locations poll

634:
635: IF (p_doc_line_loc_id IS NULL) THEN
636: SELECT poll.line_location_id
637: INTO x_doc_line_loc_id
638: FROM po_line_locations poll
639: WHERE poll.shipment_num = p_doc_shipment_num AND
640: poll.po_line_id = x_doc_line_id AND
641: poll.po_header_id = x_doc_id;
642: ELSE

Line 645: FROM po_line_locations poll

641: poll.po_header_id = x_doc_id;
642: ELSE
643: SELECT 'Exists'
644: INTO l_exists
645: FROM po_line_locations poll
646: WHERE poll.line_location_id = x_doc_line_loc_id AND
647: poll.po_line_id = x_doc_line_id AND
648: poll.po_header_id = x_doc_id;
649: END IF; --

Line 832: FROM po_line_locations poll,

828: -- SQL Why: Need to derive the missing unique line_location_id
829: -- SQL Join: po_line_id
830: SELECT poll.line_location_id
831: INTO x_doc_line_loc_id
832: FROM po_line_locations poll,
833: po_lines pol
834: WHERE poll.po_release_id = x_doc_id AND
835: poll.po_header_id = l_release_po_header_id AND
836: poll.po_line_id = pol.po_line_id AND

Line 842: FROM po_line_locations poll

838: pol.po_header_id = l_release_po_header_id;
839: ELSE
840: SELECT 'Exists'
841: INTO l_exists
842: FROM po_line_locations poll
843: WHERE poll.line_location_id = x_doc_line_loc_id AND
844: poll.po_release_id = x_doc_id;
845: END IF; --
846: