DBA Data[Home] [Help]

APPS.AHL_CMP_PVT dependencies on MTL_SECONDARY_INVENTORIES

Line 439: FROM MTL_SECONDARY_INVENTORIES

435:
436: --Sub Inventory Query
437: CURSOR AHL_SUBINV_CUR (p_org_id NUMBER, p_subinv VARCHAR2) IS
438: SELECT 1
439: FROM MTL_SECONDARY_INVENTORIES
440: WHERE ORGANIZATION_ID = p_org_id
441: AND SECONDARY_INVENTORY_NAME = p_subinv;
442:
443: -- Locator Query

Line 3724: FROM MTL_SECONDARY_INVENTORIES

3720: ELSE
3721:
3722: SELECT RESERVABLE_TYPE
3723: INTO l_reservable
3724: FROM MTL_SECONDARY_INVENTORIES
3725: WHERE ORGANIZATION_ID = p_x_ahl_mtlrtn_tbl(i).Organization_Id
3726: AND SECONDARY_INVENTORY_NAME = p_x_ahl_mtlrtn_tbl(i).Dst_SubInv_Name ;
3727:
3728: IF (l_reservable <> 1) THEN