APPS.INV_SUB_CG_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS

Line 51: --from mtl_material_transactions mmt

47:
48: -- cursor mmt_cursor (v_cost_group_id number)
49: -- is
50: --select count(*)
51: --from mtl_material_transactions mmt
52: --where mmt.cost_group_id = v_cost_group_id
53: -- or mmt.transfer_cost_group_id = v_cost_group_id;
54:
55:

Line 61: from mtl_material_transactions_temp mmtt

57:
58: cursor mmtt_cursor (v_cost_group_id number)
59: is
60: select count(*)
61: from mtl_material_transactions_temp mmtt
62: where mmtt.cost_group_id = v_cost_group_id;
63:
64: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
65: l_return_value boolean := FALSE;

Line 288: FROM mtl_material_transactions_temp mmtt

284: SELECT 'Y' INTO l_cannot_delete FROM dual
285: WHERE
286: exists
287: (SELECT organization_id
288: FROM mtl_material_transactions_temp mmtt
289: WHERE
290: (mmtt.cost_group_id = p_cost_group_id
291: OR mmtt.transfer_cost_group_id = p_cost_group_id));
292: EXCEPTION

Line 318: FROM mtl_material_transactions mmt

314: SELECT 'Y' INTO l_cannot_delete FROM dual
315: WHERE
316: exists
317: (SELECT organization_id
318: FROM mtl_material_transactions mmt
319: WHERE
320: (mmt.cost_group_id = p_cost_group_id
321: OR mmt.transfer_cost_group_id = p_cost_group_id));
322: EXCEPTION

Line 362: FROM mtl_material_transactions_temp mmtt

358: SELECT 'Y' INTO l_cannot_delete FROM dual
359: WHERE
360: exists
361: (SELECT organization_id
362: FROM mtl_material_transactions_temp mmtt
363: WHERE
364: mmtt.organization_id = p_organization_id AND
365: (mmtt.cost_group_id = p_cost_group_id
366: OR mmtt.transfer_cost_group_id = p_cost_group_id));

Line 393: FROM mtl_material_transactions mmt

389: SELECT 'Y' INTO l_cannot_delete FROM dual
390: WHERE
391: exists
392: (SELECT organization_id
393: FROM mtl_material_transactions mmt
394: WHERE mmt.organization_id = p_organization_id AND
395: (mmt.cost_group_id = p_cost_group_id
396: OR mmt.transfer_cost_group_id = p_cost_group_id));
397: EXCEPTION