APPS.CST_ACCRUAL_LOAD dependencies on MTL_TRANSACTION_ACCOUNTS

Line 1869: mtl_transaction_accounts mta,

1865: pawo.program_application_id,
1866: pawo.program_id,
1867: pawo.program_update_date
1868: FROM po_accrual_write_offs_all pawo,
1869: mtl_transaction_accounts mta,
1870: xla_distribution_links xld
1871: ,cst_accrual_accounts ca --BUG#7528609
1872: WHERE pawo.transaction_source_code = 'INV'
1873: AND pawo.org_id = p_operating_unit

Line 1881: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

1877: AND ca.operating_unit_id = p_operating_unit
1878: --}
1879: AND mta.transaction_date BETWEEN p_upg_from_date AND p_upg_to_date
1880: AND xld.source_distribution_id_num_1 = mta.inv_sub_ledger_id
1881: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
1882: AND xld.application_id = 707
1883: GROUP BY pawo.write_off_id,
1884: pawo.write_off_gl_date,
1885: pawo.accrual_account_id,

Line 1973: mtl_transaction_accounts mta,

1969: cwo.program_id,
1970: cwo.program_update_date
1971: FROM cst_write_offs cwo,
1972: po_accrual_write_offs_all pawo,
1973: mtl_transaction_accounts mta,
1974: xla_distribution_links xld,
1975: cst_accrual_accounts ca --BUG7528609
1976: WHERE pawo.org_id = p_operating_unit
1977: AND pawo.transaction_source_code ='INV'

Line 1986: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'

1982: AND mta.reference_account = ca.accrual_account_id
1983: --}
1984: AND mta.transaction_date BETWEEN p_upg_from_date AND p_upg_to_date
1985: AND xld.source_distribution_id_num_1 = mta.inv_sub_ledger_id
1986: AND xld.source_distribution_type = 'MTL_TRANSACTION_ACCOUNTS'
1987: AND xld.application_id = 707;
1988:
1989:
1990: debug(' Done Updating the write off details for INV');