APPS.CST_ACCRUAL_LOAD dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2876: mtl_material_transactions mmt,

2872: xal.ae_line_num
2873: FROM xla_ae_headers xah,
2874: xla_ae_lines xal,
2875: xla_transaction_entities_upg xte,
2876: mtl_material_transactions mmt,
2877: cst_accrual_accounts caa,
2878: financials_system_params_all fsp
2879: WHERE xal.code_combination_id = caa.accrual_account_id
2880: AND caa.operating_unit_id = p_operating_unit

Line 3012: mtl_material_transactions mmt,

3008: xal.ae_line_num
3009: FROM xla_ae_headers xah,
3010: xla_ae_lines xal,
3011: xla_transaction_entities_upg xte,
3012: mtl_material_transactions mmt,
3013: cst_accrual_accounts caa,
3014: financials_system_params_all fsp,
3015: mtl_parameters mp /* Bug 13728770 */
3016: WHERE xal.code_combination_id = caa.accrual_account_id

Line 3094: mtl_material_transactions mmt,

3090: xal.ae_line_num
3091: FROM xla_ae_headers xah,
3092: xla_ae_lines xal,
3093: xla_transaction_entities_upg xte,
3094: mtl_material_transactions mmt,
3095: cst_accrual_accounts caa,
3096: financials_system_params_all fsp,
3097: mtl_parameters mp /* Bug 13728770 */
3098: WHERE xal.code_combination_id = caa.accrual_account_id

Line 3163: FROM mtl_material_transactions mmt,

3159:
3160: UPDATE cst_misc_reconciliation cmr
3161: SET cmr.vendor_id = (
3162: SELECT mip.vendor_id
3163: FROM mtl_material_transactions mmt,
3164: mtl_intercompany_parameters mip,
3165: hr_organization_information hoi1,
3166: hr_organization_information hoi2
3167: WHERE mmt.transaction_id = cmr.inventory_transaction_id

Line 3203: from mtl_material_transactions mmt

3199: from mtl_consumption_transactions mct
3200: where mct.consumption_processed_flag = 'Y'
3201: AND mct.transaction_id in
3202: (select transaction_id
3203: from mtl_material_transactions mmt
3204: where mmt.transaction_id = cmr.inventory_transaction_id
3205: or mmt.transfer_transaction_id = cmr.inventory_transaction_id
3206: )
3207: )