DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on MTL_SECONDARY_LOCATORS

Line 3452: FROM mtl_item_locations_kfv a, mtl_secondary_locators b

3448: OPEN x_locators FOR
3449: SELECT a.inventory_location_id
3450: , a.concatenated_segments
3451: , a.description
3452: FROM mtl_item_locations_kfv a, mtl_secondary_locators b
3453: WHERE b.organization_id = l_org
3454: AND b.inventory_item_id = p_inventory_item_id
3455: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3456: AND b.subinventory_code = p_subinventory_code

Line 3518: FROM mtl_item_locations a, mtl_secondary_locators b

3514: OPEN x_locators FOR
3515: SELECT a.inventory_location_id
3516: , inv_project.get_locsegs(a.inventory_location_id,l_org)
3517: , NVL(a.description, -1)
3518: FROM mtl_item_locations a, mtl_secondary_locators b
3519: WHERE b.organization_id = l_org
3520: AND b.inventory_item_id = p_inventory_item_id
3521: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3522: AND b.subinventory_code = p_subinventory_code