APPS.CST_ACCRUAL_LOAD dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 1254: ap_invoice_distributions_all aida,

1250: pawo.program_id,
1251: pawo.program_update_date
1252: FROM
1253: po_accrual_write_offs_all pawo,
1254: ap_invoice_distributions_all aida,
1255: financials_system_params_all fsp,
1256: gl_sets_of_books gsob,
1257: fnd_currencies fc,
1258: ap_ae_lines_all aal,

Line 1389: ap_invoice_distributions_all aida,

1385: pawo.program_id,
1386: pawo.program_update_date
1387: FROM
1388: po_accrual_write_offs_all pawo,
1389: ap_invoice_distributions_all aida,
1390: financials_system_params_all fsp,
1391: gl_sets_of_books gsob,
1392: fnd_currencies fc,
1393: ap_ae_lines_all aal,

Line 1536: ap_invoice_distributions_all aida,

1532: po_accrual_write_offs_all pawo,
1533: po_distributions_all pod,
1534: po_releases_all pra,
1535: po_headers_all poh,
1536: ap_invoice_distributions_all aida,
1537: financials_system_params_all fsp,
1538: gl_sets_of_books gsob,
1539: fnd_currencies fc,
1540: ap_ae_lines aal,

Line 1704: ap_invoice_distributions_all aida,

1700: po_accrual_write_offs_all pawo,
1701: po_distributions_all pod,
1702: po_releases_all pra,
1703: po_headers_all poh,
1704: ap_invoice_distributions_all aida,
1705: financials_system_params_all fsp,
1706: gl_sets_of_books gsob,
1707: fnd_currencies fc,
1708: ap_ae_lines aal,

Line 2145: ap_invoice_distributions_all aida,

2141: --}
2142: FROM cst_write_offs cwo,
2143: po_accrual_write_offs_all pawo,
2144: po_lookup_codes plc,
2145: ap_invoice_distributions_all aida,
2146: ap_ae_lines_all aal,
2147: cst_accrual_accounts ca, --BUG#7528609
2148: xla_distribution_links xld
2149: ,xla_ae_lines xlal --XLD AP <=> n XLA AE line AP with different GL Accounts

Line 2492: ap_invoice_distributions_all aida,

2488: l_program_update_date,
2489: xla.ae_header_id,
2490: xla.ae_line_num
2491: FROM AP_MISC_TRANSACTIONS_XLA xla,
2492: ap_invoice_distributions_all aida,
2493: ap_invoices_all apia,
2494: po_distributions_all pod,
2495: po_lines_all pol,
2496: po_headers_all poh

Line 3483: FROM ap_invoice_distributions_all aida,

3479: --10 LOGICAL_RETURN_TO_VENDOR
3480: ----------------------
3481: UNION
3482: SELECT DISTINCT aida.po_distribution_id
3483: FROM ap_invoice_distributions_all aida,
3484: po_distributions_all pod
3485: WHERE pod.accrual_account_id is NOT NULL
3486: AND aida.accounting_date between p_from_date AND p_to_date
3487: AND aida.po_distribution_id is NOT NULL

Line 3928: FROM ap_invoice_distributions_all

3924: ,po_distribution_id
3925: ,rcv_transaction_id
3926: ,LINE_TYPE_LOOKUP_CODE
3927: ,org_id
3928: FROM ap_invoice_distributions_all
3929: WHERE po_distribution_id = po_dists_tab(indx)
3930: UNION ALL
3931: SELECT 'APSTD' tn
3932: ,invoice_id

Line 3944: -- ap_invoice_distributions_all aida,

3940: ,LINE_TYPE_LOOKUP_CODE
3941: ,org_id
3942: FROM ap_self_assessed_tax_dist_all
3943: WHERE po_distribution_id = po_dists_tab(indx)) aida,
3944: -- ap_invoice_distributions_all aida,
3945: --}
3946: xla_ae_headers xah,
3947: xla_ae_lines xal,
3948: xla_distribution_links xdl,