APPS.INV_MATERIAL_STATUS_GRP dependencies on MTL_SECONDARY_INVENTORIES

Line 1036: from mtl_secondary_inventories

1032: -- then retrieve status_id from MOQD.
1033: if (l_default_status_id is null) then
1034: select status_id
1035: into g_isa_sub_status_id
1036: from mtl_secondary_inventories
1037: where organization_id = p_organization_id
1038: and secondary_inventory_name = p_sub_code;
1039: g_isa_organization_id := p_organization_id;
1040: g_isa_sub_code := p_sub_code;

Line 2164: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b

2160: RETURN 'Y';
2161: ELSE
2162: SELECT count(*)
2163: INTO l_temp
2164: FROM mtl_secondary_inventories a, mtl_item_sub_inventories b
2165: WHERE a.organization_id = p_org_id
2166: AND b.inventory_item_id = p_inventory_item_id
2167: AND a.organization_id = b.organization_id
2168: AND a.secondary_inventory_name = b.secondary_inventory

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

2701: SELECT (decode(P.STOCK_LOCATOR_CONTROL_CODE,4,
2702: decode(S.LOCATOR_TYPE,5,I.LOCATION_CONTROL_CODE,S.LOCATOR_TYPE),
2703: P.STOCK_LOCATOR_CONTROL_CODE))
2704: INTO l_loc_control
2705: FROM MTL_PARAMETERS P,MTL_SECONDARY_INVENTORIES S,MTL_SYSTEM_ITEMS I
2706: WHERE I.INVENTORY_ITEM_ID = p_inventory_item_id
2707: AND I.ORGANIZATION_ID = p_org_id
2708: AND S.SECONDARY_INVENTORY_NAME = p_sub_code
2709: AND I.ORGANIZATION_ID = S.ORGANIZATION_ID