DBA Data[Home] [Help]

APPS.INV_VALIDATE dependencies on MTL_SECONDARY_LOCATORS

Line 1208: FROM MTL_SECONDARY_LOCATORS

1204: AND SUBINVENTORY_CODE = p_sub.secondary_inventory_name
1205: AND (DISABLE_DATE > SYSDATE OR DISABLE_DATE IS NULL)
1206: AND INVENTORY_LOCATION_ID IN
1207: (SELECT SECONDARY_LOCATOR
1208: FROM MTL_SECONDARY_LOCATORS
1209: WHERE INVENTORY_ITEM_ID = p_item.inventory_item_id
1210: AND ORGANIZATION_ID = p_org.organization_id
1211: AND NVL(PROJECT_ID,-1) = NVL(p_project_id,-1)
1212: AND NVL(TASK_ID,-1) = NVL(p_task_id,-1)

Line 1738: FROM mtl_item_locations mil,mtl_secondary_locators msl

1734: end if;
1735:
1736: SELECT mil.*
1737: INTO p_locator
1738: FROM mtl_item_locations mil,mtl_secondary_locators msl
1739: WHERE mil.organization_id = p_org.organization_id
1740: AND mil.subinventory_code = p_sub.secondary_inventory_name
1741: AND mil.inventory_location_id = p_locator.inventory_location_id
1742: AND NVL(disable_date,SYSDATE) >= SYSDATE