DBA Data[Home] [Help]

APPS.CST_ACCRUAL_LOAD dependencies on MTL_MATERIAL_TRANSACTIONS

Line 2669: mtl_material_transactions mmt,

2665: xal.ae_line_num
2666: FROM xla_ae_headers xah,
2667: xla_ae_lines xal,
2668: xla_transaction_entities_upg xte,
2669: mtl_material_transactions mmt,
2670: cst_accrual_accounts caa,
2671: financials_system_params_all fsp
2672: WHERE xal.code_combination_id = caa.accrual_account_id
2673: AND caa.operating_unit_id = p_operating_unit

Line 2799: mtl_material_transactions mmt,

2795: xal.ae_line_num
2796: FROM xla_ae_headers xah,
2797: xla_ae_lines xal,
2798: xla_transaction_entities_upg xte,
2799: mtl_material_transactions mmt,
2800: cst_accrual_accounts caa,
2801: financials_system_params_all fsp
2802: WHERE xal.code_combination_id = caa.accrual_account_id
2803: AND caa.operating_unit_id = p_operating_unit

Line 2865: FROM mtl_material_transactions mmt,

2861:
2862: UPDATE cst_misc_reconciliation cmr
2863: SET cmr.vendor_id = (
2864: SELECT mip.vendor_id
2865: FROM mtl_material_transactions mmt,
2866: mtl_intercompany_parameters mip,
2867: hr_organization_information hoi1,
2868: hr_organization_information hoi2
2869: WHERE mmt.transaction_id = cmr.inventory_transaction_id

Line 2905: from mtl_material_transactions mmt

2901: from mtl_consumption_transactions mct
2902: where mct.consumption_processed_flag = 'Y'
2903: AND mct.transaction_id in
2904: (select transaction_id
2905: from mtl_material_transactions mmt
2906: where mmt.transaction_id = cmr.inventory_transaction_id
2907: or mmt.transfer_transaction_id = cmr.inventory_transaction_id
2908: )
2909: )