DBA Data[Home] [Help]

APPS.PO_DOCUMENT_FUNDS_PVT dependencies on PO_LINES_ALL

Line 3330: SELECT po_header_id into l_po_document_id FROM po_lines_all

3326: IF p_doc_type ='PO' OR p_doc_type='PA' THEN
3327: IF p_doc_level ='HEADER' THEN
3328: l_po_document_id := p_doc_level_id;
3329: ELSIF p_doc_level='LINE' THEN
3330: SELECT po_header_id into l_po_document_id FROM po_lines_all
3331: WHERE po_line_id = p_doc_level_id ;
3332: ELSIF p_doc_level='SHIPMENT' THEN
3333: SELECT po_header_id into l_po_document_id FROM po_line_locations_all
3334: WHERE line_location_id = p_doc_level_id ;

Line 4895: , PO_LINES_ALL POL

4891: , POD.amount_changed_flag -- <13503748>
4892: FROM
4893: PO_DISTRIBUTIONS_ALL POD
4894: , PO_LINE_LOCATIONS_ALL POLL
4895: , PO_LINES_ALL POL
4896: , PO_HEADERS_ALL POH
4897: , PO_SESSION_GT DIST_IDS
4898: WHERE POH.po_header_id = POD.po_header_id --JOIN
4899: AND POL.po_line_id(+) = POD.po_line_id --JOIN