eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSTPPPSC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 894: FROM mtl_material_transactions mmt

890: l_closing_pac_period_id NUMBER,
891: l_entity_id NUMBER,
892: l_cost_type_id NUMBER) IS
893: SELECT count(1)
894: FROM mtl_material_transactions mmt
895: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
896: FROM cst_pac_process_phases cppp
897: WHERE
898: (( cppp.process_phase <= 5

Line 1119: FROM mtl_material_transactions_temp mmtt

1115: /* **************************************************************************** */
1116:
1117: CURSOR cur_mmtt(l_current_cost_group_id NUMBER,l_closing_pac_period_id NUMBER) IS
1118: SELECT count(1)
1119: FROM mtl_material_transactions_temp mmtt
1120: WHERE NVL(mmtt.transaction_status,0) <> 2
1121: AND mmtt.organization_id IN
1122: (select ccga.organization_id
1123: from cst_cost_group_assignments ccga