APPS.AHL_VWP_RULES_PVT dependencies on AHL_UNIT_EFFECTIVITIES_V

Line 1167: FROM ahl_unit_effectivities_v

1163: WHERE mr_header_id = c_mr_id;
1164:
1165: CURSOR c_unit_eff_title(c_unit_eff_id IN NUMBER) IS
1166: SELECT substrb(title,1,80), description /*Bug 5758813 - Fetch the description.*/
1167: FROM ahl_unit_effectivities_v
1168: WHERE unit_effectivity_id = c_unit_eff_id;
1169:
1170: /*Bug 5758813 - rnahata - Route title and route remarks should be passed
1171: to visit as visit task name and visit task description*/

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