DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_SECONDARY_LOCATORS

Line 1202: FROM MTL_SECONDARY_LOCATORS

1198: AND SUBINVENTORY_CODE = p_sub.secondary_inventory_name
1199: AND (DISABLE_DATE > SYSDATE OR DISABLE_DATE IS NULL)
1200: AND INVENTORY_LOCATION_ID IN
1201: (SELECT SECONDARY_LOCATOR
1202: FROM MTL_SECONDARY_LOCATORS
1203: WHERE INVENTORY_ITEM_ID = p_item.inventory_item_id
1204: AND ORGANIZATION_ID = p_org.organization_id
1205: AND NVL(PROJECT_ID,-1) = NVL(p_project_id,-1)
1206: AND NVL(TASK_ID,-1) = NVL(p_task_id,-1)

Line 1613: FROM mtl_item_locations mil,mtl_secondary_locators msl

1609: end if;
1610:
1611: SELECT mil.*
1612: INTO p_locator
1613: FROM mtl_item_locations mil,mtl_secondary_locators msl
1614: WHERE mil.organization_id = p_org.organization_id
1615: AND mil.subinventory_code = p_sub.secondary_inventory_name
1616: AND mil.inventory_location_id = p_locator.inventory_location_id
1617: AND NVL(disable_date,SYSDATE) >= SYSDATE