DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1276: ap_invoice_distributions_all aida,

1272: pawo.program_id,
1273: pawo.program_update_date
1274: FROM
1275: po_accrual_write_offs_all pawo,
1276: ap_invoice_distributions_all aida,
1277: financials_system_params_all fsp,
1278: gl_sets_of_books gsob,
1279: fnd_currencies fc,
1280: ap_ae_lines_all aal,

Line 1410: ap_invoice_distributions_all aida,

1406: pawo.program_id,
1407: pawo.program_update_date
1408: FROM
1409: po_accrual_write_offs_all pawo,
1410: ap_invoice_distributions_all aida,
1411: financials_system_params_all fsp,
1412: gl_sets_of_books gsob,
1413: fnd_currencies fc,
1414: ap_ae_lines_all aal,

Line 1556: ap_invoice_distributions_all aida,

1552: po_accrual_write_offs_all pawo,
1553: po_distributions_all pod,
1554: po_releases_all pra,
1555: po_headers_all poh,
1556: ap_invoice_distributions_all aida,
1557: financials_system_params_all fsp,
1558: gl_sets_of_books gsob,
1559: fnd_currencies fc,
1560: ap_ae_lines aal,

Line 1723: ap_invoice_distributions_all aida,

1719: po_accrual_write_offs_all pawo,
1720: po_distributions_all pod,
1721: po_releases_all pra,
1722: po_headers_all poh,
1723: ap_invoice_distributions_all aida,
1724: financials_system_params_all fsp,
1725: gl_sets_of_books gsob,
1726: fnd_currencies fc,
1727: ap_ae_lines aal,

Line 2133: ap_invoice_distributions_all aida,

2129: cwo.program_update_date
2130: FROM cst_write_offs cwo,
2131: po_accrual_write_offs_all pawo,
2132: po_lookup_codes plc,
2133: ap_invoice_distributions_all aida,
2134: ap_ae_lines_all aal,
2135: cst_accrual_accounts ca, --BUG#7528609
2136: xla_distribution_links xld
2137: WHERE pawo.org_id = p_operating_unit

Line 2390: ap_invoice_distributions_all aida,

2386: l_program_update_date,
2387: xal.ae_header_id,
2388: xal.ae_line_num
2389: FROM ap_invoices_all apia,
2390: ap_invoice_distributions_all aida,
2391: xla_ae_headers xah,
2392: xla_ae_lines xal,
2393: xla_distribution_links xdl,
2394: cst_accrual_accounts caa,

Line 3179: FROM ap_invoice_distributions_all aida,

3175: --10 LOGICAL_RETURN_TO_VENDOR
3176: ----------------------
3177: UNION
3178: SELECT DISTINCT aida.po_distribution_id
3179: FROM ap_invoice_distributions_all aida,
3180: po_distributions_all pod
3181: WHERE pod.accrual_account_id is NOT NULL
3182: AND aida.accounting_date between p_from_date AND p_to_date
3183: AND aida.po_distribution_id is NOT NULL

Line 3582: ap_invoice_distributions_all aida,

3578: l_request_id,
3579: xal.ae_header_id,
3580: xal.ae_line_num
3581: FROM
3582: ap_invoice_distributions_all aida,
3583: xla_ae_headers xah,
3584: xla_ae_lines xal,
3585: xla_distribution_links xdl,
3586: po_lines_all pol,