2531: , g_order_type_RATE, 'Y'
2532: , 'N'
2533: )
2534: INTO l_amt_based_line_flag
2535: FROM PO_LINE_LOCATIONS_ALL PLL
2536: , PO_DISTRIBUTIONS_ALL POD
2537: WHERE POD.po_distribution_id = p_distribution_id
2538: AND PLL.line_location_id = POD.line_location_id
2539: ;
3274: ELSIF p_doc_level='LINE' THEN
3275: SELECT po_header_id into l_po_document_id FROM po_lines_all
3276: WHERE po_line_id = p_doc_level_id ;
3277: ELSIF p_doc_level='SHIPMENT' THEN
3278: SELECT po_header_id into l_po_document_id FROM po_line_locations_all
3279: WHERE line_location_id = p_doc_level_id ;
3280: ELSIF p_doc_level='DISTRIBUTION' THEN
3281: SELECT po_header_id into l_po_document_id FROM po_distributions_all
3282: WHERE po_distribution_id = p_doc_level_id ;
3284: END IF;
3285:
3286: IF p_doc_type ='RELEASE' THEN
3287: IF p_doc_level='SHIPMENT' THEN
3288: SELECT po_header_id into l_rel_document_id FROM po_line_locations_all
3289: WHERE line_location_id = p_doc_level_id ;
3290: ELSIF p_doc_level='DISTRIBUTION' THEN
3291: SELECT po_header_id into l_rel_document_id FROM po_distributions_all
3292: WHERE po_distribution_id = p_doc_level_id ;
4658: , POD.expenditure_item_date
4659: , POH.vendor_id
4660: FROM
4661: PO_DISTRIBUTIONS_ALL POD
4662: , PO_LINE_LOCATIONS_ALL POLL
4663: , PO_LINES_ALL POL
4664: , PO_HEADERS_ALL POH
4665: , PO_SESSION_GT DIST_IDS
4666: WHERE POH.po_header_id = POD.po_header_id --JOIN