DBA Data[Home] [Help]

APPS.IGC_CC_COMP_AMT_PKG dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 32: ap_invoice_distributions_all apid,

28:
29: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
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

Line 113: ap_invoice_distributions_all apid,

109:
110: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
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

Line 430: ap_invoice_distributions_all apid,

426:
427: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
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

Line 499: ap_invoice_distributions_all apid,

495:
496: SELECT NVL(SUM(DECODE(apid.base_amount,NULL,apid.amount,apid.base_amount)),0)
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