APPS.IGC_CC_COMP_AMT_PKG dependencies on PO_LINES_ALL

Line 35: po_lines_all pol,

31: FROM
32: ap_invoice_distributions_all apid,
33: po_distributions_all pod,
34: po_line_locations_all pll,
35: po_lines_all pol,
36: po_headers_all poh
37: WHERE
38: apid.po_distribution_id = pod.po_distribution_id AND
39: apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND

Line 116: po_lines_all pol,

112: FROM
113: ap_invoice_distributions_all apid,
114: po_distributions_all pod,
115: po_line_locations_all pll,
116: po_lines_all pol,
117: po_headers_all poh
118: WHERE
119: apid.po_distribution_id = pod.po_distribution_id AND
120: apid.LINE_TYPE_LOOKUP_CODE = 'ITEM' AND

Line 195: po_lines_all pol,

191: SELECT NVL(pod.amount_billed,0)
192: INTO l_billed_amount
193: FROM
194: po_headers_all poh,
195: po_lines_all pol,
196: po_line_locations_all pll,
197: po_distributions_all pod
198: WHERE
199: poh.segment1 = l_cc_num AND

Line 300: po_lines_all pol,

296: SELECT NVL(SUM(NVL(pod.amount_billed,0)),0)
297: INTO l_billed_amount
298: FROM
299: po_headers_all poh,
300: po_lines_all pol,
301: po_line_locations_all pll,
302: po_distributions_all pod
303: WHERE
304: poh.segment1 = l_cc_num AND

Line 433: po_lines_all pol,

429: FROM
430: ap_invoice_distributions_all apid,
431: po_distributions_all pod,
432: po_line_locations_all pll,
433: po_lines_all pol,
434: po_headers_all poh
435: WHERE
436: apid.po_distribution_id = pod.po_distribution_id AND
437: poh.segment1 = l_cc_num AND

Line 502: po_lines_all pol,

498: FROM
499: ap_invoice_distributions_all apid,
500: po_distributions_all pod,
501: po_line_locations_all pll,
502: po_lines_all pol,
503: po_headers_all poh
504: WHERE
505: apid.po_distribution_id = pod.po_distribution_id AND
506: poh.segment1 = l_cc_num AND