DBA Data[Home] [Help]

APPS.INV_SUB_CG_UTIL dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

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 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));