APPS.WIP_LOCATOR dependencies on MTL_SECONDARY_LOCATORS

Line 67: '(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||

63: '(DISABLE_DATE > SYSDATE OR ' ||
64: 'DISABLE_DATE IS NULL) AND SUBINVENTORY_CODE = ' ||
65: P_Subinventory_Code
66: || ' AND INVENTORY_LOCATION_ID IN ' ||
67: '(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||
68: 'WHERE INVENTORY_ITEM_ID = ' ||
69: TO_CHAR(P_Item_Id) ||
70: ' AND ORGANIZATION_ID = ' || to_char(P_Organization_Id)
71: || ' AND SUBINVENTORY_CODE = ' || P_Subinventory_Code || ')'; */

Line 80: '(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||

76: '(DISABLE_DATE > SYSDATE OR ' ||
77: 'DISABLE_DATE IS NULL) AND SUBINVENTORY_CODE = ''' ||
78: P_Subinventory_Code ||''''
79: || ' AND INVENTORY_LOCATION_ID IN ' ||
80: '(SELECT SECONDARY_LOCATOR FROM MTL_SECONDARY_LOCATORS ' ||
81: 'WHERE INVENTORY_ITEM_ID = ''' ||
82: TO_NUMBER(P_Item_Id) ||'''' ||
83: ' AND ORGANIZATION_ID = ''' || to_number(P_Organization_Id)||''''
84: || ' AND SUBINVENTORY_CODE = ''' || P_Subinventory_Code||'''' || ')';

Line 129: FROM MTL_SECONDARY_LOCATORS

125: AND SUBINVENTORY_CODE = P_Subinventory_Code
126: AND INVENTORY_LOCATION_ID = P_Locator_Id
127: AND INVENTORY_LOCATION_ID IN
128: (SELECT SECONDARY_LOCATOR
129: FROM MTL_SECONDARY_LOCATORS
130: WHERE INVENTORY_ITEM_ID = P_Item_Id
131: AND ORGANIZATION_ID = P_Organization_Id
132: AND SUBINVENTORY_CODE = P_Subinventory_Code);
133: