APPS.CST_ACCRUAL_LOAD dependencies on MTL_TRANSACTION_ACCOUNTS

Line 1850: mtl_transaction_accounts mta,

1846: pawo.program_application_id,
1847: pawo.program_id,
1848: pawo.program_update_date
1849: FROM po_accrual_write_offs_all pawo,
1850: mtl_transaction_accounts mta,
1851: xla_distribution_links xld
1852: ,cst_accrual_accounts ca --BUG#7528609
1853: WHERE pawo.transaction_source_code = 'INV'
1854: AND pawo.org_id = p_operating_unit

Line 1862: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

1858: AND ca.operating_unit_id = p_operating_unit
1859: --}
1860: AND mta.transaction_date BETWEEN p_upg_from_date AND p_upg_to_date
1861: AND xld.source_distribution_id_num_1 = mta.inv_sub_ledger_id
1862: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
1863: AND xld.application_id = 707
1864: GROUP BY pawo.write_off_id,
1865: pawo.write_off_gl_date,
1866: pawo.accrual_account_id,

Line 1964: mtl_transaction_accounts mta,

1960: ,xld.ae_line_num
1961: --}
1962: FROM cst_write_offs cwo,
1963: po_accrual_write_offs_all pawo,
1964: mtl_transaction_accounts mta,
1965: xla_distribution_links xld,
1966: cst_accrual_accounts ca --BUG7528609
1967: WHERE pawo.org_id = p_operating_unit
1968: AND pawo.transaction_source_code ='INV'

Line 1977: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

1973: AND mta.reference_account = ca.accrual_account_id
1974: --}
1975: AND mta.transaction_date BETWEEN p_upg_from_date AND p_upg_to_date
1976: AND xld.source_distribution_id_num_1 = mta.inv_sub_ledger_id
1977: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
1978: AND xld.application_id = 707;
1979:
1980:
1981: debug(' Done Updating the write off details for INV');