APPS.INV_SUB_CG_UTIL dependencies on MTL_ONHAND_QUANTITIES_DETAIL

Line 45: -- from MTL_ONHAND_QUANTITIES_DETAIL moq

41:
42: -- cursor moq_cursor (v_cost_group_id number)
43: -- is
44: -- select count(*)
45: -- from MTL_ONHAND_QUANTITIES_DETAIL moq
46: -- where moq.cost_group_id = v_cost_group_id;
47:
48: -- cursor mmt_cursor (v_cost_group_id number)
49: -- is

Line 304: FROM MTL_ONHAND_QUANTITIES_DETAIL moq

300: SELECT 'Y' INTO l_cannot_delete FROM dual
301: WHERE
302: exists
303: (SELECT organization_id
304: FROM MTL_ONHAND_QUANTITIES_DETAIL moq
305: WHERE moq.cost_group_id = p_cost_group_id);
306: EXCEPTION
307: WHEN no_data_found THEN
308: l_cannot_delete := 'N';

Line 379: FROM MTL_ONHAND_QUANTITIES_DETAIL moq

375: SELECT 'Y' INTO l_cannot_delete FROM dual
376: WHERE
377: exists
378: (SELECT organization_id
379: FROM MTL_ONHAND_QUANTITIES_DETAIL moq
380: WHERE moq.cost_group_id = p_cost_group_id
381: AND moq.organization_id = p_organization_id);
382: EXCEPTION
383: WHEN no_data_found THEN