APPS.INV_SUB_CG_UTIL dependencies on MTL_SECONDARY_INVENTORIES

Line 274: FROM mtl_secondary_inventories msi

270: SELECT 'Y' INTO l_cannot_delete FROM dual
271: WHERE
272: exists
273: (SELECT organization_id
274: FROM mtl_secondary_inventories msi
275: WHERE msi.default_cost_group_id = p_cost_group_id);
276: EXCEPTION
277: WHEN no_data_found THEN
278: l_cannot_delete := 'N';

Line 347: from mtl_secondary_inventories msi

343: SELECT 'Y' INTO l_cannot_delete FROM dual
344: WHERE
345: exists
346: (select organization_id
347: from mtl_secondary_inventories msi
348: where msi.default_cost_group_id = p_cost_group_id
349: AND msi.organization_id = p_organization_id);
350: EXCEPTION
351: WHEN no_data_found THEN

Line 545: update mtl_secondary_inventories

541: --
542: -- Update the subinventory with the cost group's accounts
543: --
544:
545: update mtl_secondary_inventories
546: set
547: material_account = l_material_account
548: , material_overhead_account = l_material_overhead_account
549: , resource_account = l_resource_account

Line 782: from mtl_secondary_inventories

778: is
779: cursor subinventory_cursor
780: is
781: select organization_id, secondary_inventory_name
782: from mtl_secondary_inventories
783: where default_cost_group_id = p_cost_group_id;
784:
785: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
786: l_count integer := 0;

Line 1051: from mtl_secondary_inventories

1047: x_return_status := fnd_api.g_ret_sts_success;
1048:
1049: select nvl(default_cost_group_id,0)
1050: into l_cost_group_id
1051: from mtl_secondary_inventories
1052: where organization_id = p_organization_id
1053: and secondary_inventory_name = p_subinventory;
1054:
1055: return l_cost_group_id;