APPS.INVPVDR5 dependencies on MTL_SECONDARY_INVENTORIES

Line 340: FROM mtl_secondary_inventories

336:
337: CURSOR c_subinv_loc_control(cp_org_id number,
338: cp_subinv_name varchar2) IS
339: SELECT locator_type
340: FROM mtl_secondary_inventories
341: WHERE secondary_inventory_name = cp_subinv_name
342: AND organization_id = cp_org_id
343: AND SYSDATE < nvl(disable_date, SYSDATE+1);
344:

Line 1232: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i

1228:
1229: if ( l_source_restrict_sub = 1 ) then
1230: begin
1231: select 'x' into temp
1232: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i
1233: where s.SECONDARY_INVENTORY_NAME = cr.SOURCE_SUBINVENTORY
1234: and s.ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
1235: and nvl(s.DISABLE_DATE, sysdate + 1 ) > sysdate
1236: and i.INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID

Line 1249: from MTL_SECONDARY_INVENTORIES

1245: end;
1246: else
1247: begin
1248: select 'x' into temp
1249: from MTL_SECONDARY_INVENTORIES
1250: where SECONDARY_INVENTORY_NAME = cr.SOURCE_SUBINVENTORY
1251: and ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
1252: and nvl(DISABLE_DATE, sysdate + 1 ) > sysdate
1253: and 2 = decode(cr.source_organization_id, cr.organization_id,

Line 1443: FROM MTL_SECONDARY_INVENTORIES

1439: END;
1440: ELSIF NVL(cr.RESTRICT_SUBINVENTORIES_CODE,2) = 2 THEN
1441: BEGIN
1442: SELECT 'x' INTO temp
1443: FROM MTL_SECONDARY_INVENTORIES
1444: WHERE SECONDARY_INVENTORY_NAME = cr.WIP_SUPPLY_SUBINVENTORY
1445: AND ORGANIZATION_ID = cr.ORGANIZATION_ID
1446: AND SYSDATE < nvl(DISABLE_DATE, SYSDATE+1);
1447: EXCEPTION