APPS.AHL_VWP_RULES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_V

Line 1153: FROM ahl_unit_effectivities_v

1149: WHERE mr_header_id = c_mr_id;
1150:
1151: CURSOR c_unit_eff_title(c_unit_eff_id IN NUMBER) IS
1152: SELECT substr(title,1,80), description /*Bug 5758813 - Fetch the description.*/
1153: FROM ahl_unit_effectivities_v
1154: WHERE unit_effectivity_id = c_unit_eff_id;
1155:
1156: /*Bug 5758813 - rnahata - Route title and route remarks should be passed
1157: to visit as visit task name and visit task description*/

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