[Home] [Help]
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,
1259: xla_distribution_links xld
1260: ,cst_accrual_accounts ca
1261: WHERE pawo.org_id = p_operating_unit
1262: AND pawo.po_distribution_id IS NULL -- Misc Invoices
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,
1394: cst_accrual_accounts caa,
1395: xla_distribution_links xld
1396: WHERE pawo.org_id = p_operating_unit
1397: AND pawo.po_distribution_id IS NULL -- Misc Invoices
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,
1541: cst_accrual_accounts caa,
1542: xla_distribution_links xld,
1543: xla_ae_lines xal
1544: WHERE pawo.org_id = p_operating_unit
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,
1709: cst_accrual_accounts caa,
1710: xla_distribution_links xld
1711: WHERE pawo.org_id = p_operating_unit
1712: AND pawo.po_distribution_id IS NOT NULL -- Reg Invoices and consigned
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
2150: ,financials_system_params_all fsp --BUG#13869348