DBA Data[Home] [Help]

APPS.AHL_VWP_RULES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_VL

Line 1950: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI

1946:
1947: -- To find on the basis of input unit effectivity the related information
1948: CURSOR c_info(x_mr_header_id IN NUMBER, x_unit_id IN NUMBER, x_serial_id IN NUMBER) IS
1949: SELECT CSI.INV_MASTER_ORGANIZATION_ID, CSI.INVENTORY_ITEM_ID
1950: FROM AHL_UNIT_EFFECTIVITIES_VL AUEB, CSI_ITEM_INSTANCES CSI
1951: WHERE AUEB.CSI_ITEM_INSTANCE_ID = CSI.INSTANCE_ID
1952: AND AUEB.CSI_ITEM_INSTANCE_ID = x_serial_id
1953: AND (AUEB.STATUS_CODE IS NULL OR AUEB.STATUS_CODE = 'INIT-DUE')
1954: AND AUEB.UNIT_EFFECTIVITY_ID = x_unit_id