DBA Data[Home] [Help]

APPS.IGC_CC_COMP_AMT_PKG dependencies on PO_LINE_LOCATIONS_ALL

Line 34: po_line_locations_all pll,

30: INTO l_func_billed_amount
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

Line 115: po_line_locations_all pll,

111: INTO l_func_billed_amount
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

Line 196: po_line_locations_all pll,

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
200: poh.type_lookup_code = 'STANDARD' AND

Line 301: po_line_locations_all pll,

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
305: poh.type_lookup_code = 'STANDARD' AND

Line 432: po_line_locations_all pll,

428: INTO l_func_billed_amount
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

Line 501: po_line_locations_all pll,

497: INTO l_func_billed_amount
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