DBA Data[Home] [Help]

APPS.INV_TXN_VALIDATIONS dependencies on MTL_SECONDARY_LOCATORS

Line 3731: FROM mtl_item_locations_kfv a, mtl_secondary_locators b

3727: OPEN x_locators FOR
3728: SELECT a.inventory_location_id
3729: , a.concatenated_segments
3730: , a.description
3731: FROM mtl_item_locations_kfv a, mtl_secondary_locators b
3732: WHERE b.organization_id = l_org
3733: AND b.inventory_item_id = p_inventory_item_id
3734: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3735: AND b.subinventory_code = p_subinventory_code

Line 3797: FROM mtl_item_locations a, mtl_secondary_locators b

3793: OPEN x_locators FOR
3794: SELECT a.inventory_location_id
3795: , inv_project.get_locsegs(a.inventory_location_id,l_org)
3796: , NVL(a.description, -1)
3797: FROM mtl_item_locations a, mtl_secondary_locators b
3798: WHERE b.organization_id = l_org
3799: AND b.inventory_item_id = p_inventory_item_id
3800: AND NVL(a.disable_date, TRUNC(SYSDATE + 1)) > TRUNC(SYSDATE)
3801: AND b.subinventory_code = p_subinventory_code