DBA Data[Home] [Help]

APPS.PO_SUBINVENTORIES_S dependencies on MTL_ITEM_LOCATIONS

Line 169: FROM MTL_ITEM_LOCATIONS

165: IF x_locator_control = 2 THEN
166: x_progress := '010';
167: SELECT 'pre_loc_ok'
168: INTO x_status
169: FROM MTL_ITEM_LOCATIONS
170: WHERE INVENTORY_LOCATION_ID = x_locator
171: AND ORGANIZATION_ID = x_organization_id
172: AND NVL(DISABLE_DATE, SYSDATE+1) > SYSDATE;
173:

Line 480: mtl_item_locations mil

476: X_progress := '010';
477: SELECT mld.locator_id
478: INTO X_locator_id
479: FROM mtl_item_loc_defaults mld,
480: mtl_item_locations mil
481: WHERE mld.inventory_item_id = X_item_id
482: AND mld.organization_id = X_organization_id
483: AND mld.subinventory_code = X_subinventory
484: AND mld.default_type = 2