APPS.CSTPPPSC dependencies on MTL_MATERIAL_TRANSACTIONS

Line 928: FROM mtl_material_transactions mmt

924: /* Cursor to check for uncosted txn in MMT (added for bug 9648974) */
925: /* **************************************************************************** */
926: CURSOR cur_uncosted_mmt(l_current_cost_group_id NUMBER,l_closing_pac_period_id NUMBER) IS
927: SELECT count(1)
928: FROM mtl_material_transactions mmt
929: WHERE mmt.organization_id IN
930: (select ccga.organization_id
931: from cst_cost_group_assignments ccga
932: where ccga.cost_group_id = l_current_cost_group_id)

Line 953: FROM mtl_material_transactions mmt

949: l_closing_pac_period_id NUMBER,
950: l_entity_id NUMBER,
951: l_cost_type_id NUMBER) IS
952: SELECT count(1)
953: FROM mtl_material_transactions mmt
954: WHERE mmt.creation_date > ( SELECT MIN(cppp.process_date)
955: FROM cst_pac_process_phases cppp
956: WHERE
957: (( cppp.process_phase <= 5

Line 1178: FROM mtl_material_transactions_temp mmtt

1174: /* **************************************************************************** */
1175:
1176: CURSOR cur_mmtt(l_current_cost_group_id NUMBER,l_closing_pac_period_id NUMBER) IS
1177: SELECT count(1)
1178: FROM mtl_material_transactions_temp mmtt
1179: WHERE NVL(mmtt.transaction_status,0) <> 2
1180: AND mmtt.organization_id IN
1181: (select ccga.organization_id
1182: from cst_cost_group_assignments ccga

Line 1288: FROM MTL_MATERIAL_TRANSACTIONS

1284: -- period.
1285: -- ====================================================================
1286: CURSOR cur_so_txn(c_legal_entity_id NUMBER) IS
1287: SELECT 'Y'
1288: FROM MTL_MATERIAL_TRANSACTIONS
1289: WHERE transaction_source_type_id IN (2,12)
1290: AND organization_id IN (Select ccga.organization_id
1291: from cst_cost_group_assignments ccga,
1292: cst_cost_groups ccg