DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 2228: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

2224:
2225: -- To find on the basis of input unit effectivity the related information
2226: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER, x_serial_id IN NUMBER) IS
2227: SELECT CSI.INV_MASTER_ORGANIZATION_ID, CSI.INVENTORY_ITEM_ID
2228: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
2229: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
2230: AND AUEB.CSI_ITEM_INSTANCE_ID = x_serial_id
2231: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
2232: AND AUEB.UNIT_EFFECTIVITY_ID = x_unit_id