APPS.INVPVDR5 dependencies on MTL_SECONDARY_INVENTORIES

Line 342: FROM mtl_secondary_inventories

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

Line 1261: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i

1257:
1258: if ( l_source_restrict_sub = 1 ) then
1259: begin
1260: select 'x' into temp
1261: from MTL_SECONDARY_INVENTORIES s, MTL_ITEM_SUB_INVENTORIES i
1262: where s.SECONDARY_INVENTORY_NAME = cr.SOURCE_SUBINVENTORY
1263: and s.ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
1264: and nvl(s.DISABLE_DATE, sysdate + 1 ) > sysdate
1265: and i.INVENTORY_ITEM_ID = cr.INVENTORY_ITEM_ID

Line 1278: from MTL_SECONDARY_INVENTORIES

1274: end;
1275: else
1276: begin
1277: select 'x' into temp
1278: from MTL_SECONDARY_INVENTORIES
1279: where SECONDARY_INVENTORY_NAME = cr.SOURCE_SUBINVENTORY
1280: and ORGANIZATION_ID = cr.SOURCE_ORGANIZATION_ID
1281: and nvl(DISABLE_DATE, sysdate + 1 ) > sysdate
1282: and 2 = decode(cr.source_organization_id, cr.organization_id,

Line 1472: FROM MTL_SECONDARY_INVENTORIES

1468: END;
1469: ELSIF NVL(cr.RESTRICT_SUBINVENTORIES_CODE,2) = 2 THEN
1470: BEGIN
1471: SELECT 'x' INTO temp
1472: FROM MTL_SECONDARY_INVENTORIES
1473: WHERE SECONDARY_INVENTORY_NAME = cr.WIP_SUPPLY_SUBINVENTORY
1474: AND ORGANIZATION_ID = cr.ORGANIZATION_ID
1475: AND SYSDATE < nvl(DISABLE_DATE, SYSDATE+1);
1476: EXCEPTION