APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_SECONDARY_INVENTORIES

Line 1013: from mtl_secondary_inventories

1009: -- then retrieve status_id from MOQD.
1010: if (l_default_status_id is null) then
1011: select status_id
1012: into g_isa_sub_status_id
1013: from mtl_secondary_inventories
1014: where organization_id = p_organization_id
1015: and secondary_inventory_name = p_sub_code;
1016: g_isa_organization_id := p_organization_id;
1017: g_isa_sub_code := p_sub_code;

Line 1776: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

1772: RETURN 'Y';
1773: ELSE
1774: SELECT count(*)
1775: INTO l_temp
1776: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
1777: WHERE a.organization_id = p_org_id
1778: AND b.inventory_item_id = p_inventory_item_id
1779: AND a.organization_id = b.organization_id
1780: AND a.secondary_inventory_name = b.secondary_inventory

Line 2199: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I

2195: SELECT (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,
2196: decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE,S.LOCATOR_TYPE),
2197: P.STOCK_LOCATOR_CONTROL_CODE))
2198: INTO l_loc_control
2199: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
2200: WHERE I.INVENTORY_ITEM_ID = p_inventory_item_id
2201: AND I.ORGANIZATION_ID = p_org_id
2202: AND S.SECONDARY_INVENTORY_NAME = p_sub_code
2203: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID