APPS.INVPVDR7 dependencies on MTL_SECONDARY_INVENTORIES

Line 45: FROM mtl_secondary_inventories

41:
42: CURSOR c_subinv_loc_control(cp_org_id number,
43: cp_subinv_name varchar2) IS
44: SELECT locator_type
45: FROM mtl_secondary_inventories
46: WHERE secondary_inventory_name = cp_subinv_name
47: AND organization_id = cp_org_id
48: AND SYSDATE < nvl(disable_date, SYSDATE+1);
49:

Line 747: from MTL_SECONDARY_INVENTORIES

743: end;
744: elsif NVL(cr.RESTRICT_SUBINVENTORIES_CODE,2) = 2 then
745: begin
746: select 'x' INTO l_temp
747: from MTL_SECONDARY_INVENTORIES
748: where SECONDARY_INVENTORY_NAME = cr.PROCESS_SUPPLY_SUBINVENTORY
749: and ORGANIZATION_ID = cr.ORGANIZATION_ID
750: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1);
751:

Line 931: from MTL_SECONDARY_INVENTORIES

927: end;
928: elsif NVL(cr.RESTRICT_SUBINVENTORIES_CODE,2) = 2 then
929: begin
930: select 'x' INTO l_temp
931: from MTL_SECONDARY_INVENTORIES
932: where SECONDARY_INVENTORY_NAME = cr.PROCESS_YIELD_SUBINVENTORY
933: and ORGANIZATION_ID = cr.ORGANIZATION_ID
934: and SYSDATE < nvl(DISABLE_DATE, SYSDATE+1);
935: