APPS.AHL_PRD_WORKORDER_PVT dependencies on AHL_VISIT_TASKS_B

Line 1415: FROM AHL_VISIT_TASKS_B

1411: END IF;
1412:
1413: SELECT COUNT(*)
1414: INTO l_dummy_ctr
1415: FROM AHL_VISIT_TASKS_B
1416: WHERE visit_task_id=p_prd_workorder_rec.visit_task_id;
1417:
1418: IF l_dummy_ctr=0 THEN
1419: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_visit_task_invalid');

Line 1755: ahl_visit_tasks_b vtsk,

1751: IS
1752: SELECT
1753: nvl(vtsk.quantity, 1)
1754: FROM
1755: ahl_visit_tasks_b vtsk,
1756: ahl_workorders awo
1757: WHERE
1758: vtsk.visit_task_id = awo.visit_task_id AND
1759: awo.workorder_id = p_workorder_id;

Line 1938: ahl_visit_tasks_b vtsk,

1934: IS
1935: SELECT
1936: nvl(vtsk.quantity, 1)
1937: FROM
1938: ahl_visit_tasks_b vtsk,
1939: ahl_workorders awo
1940: WHERE
1941: vtsk.visit_task_id = awo.visit_task_id AND
1942: awo.workorder_id = p_workorder_id;

Line 2524: AHL_VISIT_TASKS_B VTSK,

2520: SELECT
2521: CSIA.summary, -- sr summary
2522: CSIT.name -- sr type attribute
2523: FROM
2524: AHL_VISIT_TASKS_B VTSK,
2525: AHL_UNIT_EFFECTIVITIES_B UE,
2526: CS_INCIDENTS_ALL CSIA,
2527: CS_INCIDENT_TYPES_VL CSIT
2528: WHERE

Line 2843: ahl_visit_tasks_b vtsk

2839: IS
2840: SELECT
2841: 'X'
2842: FROM
2843: ahl_visit_tasks_b vtsk
2844: WHERE
2845: vtsk.quantity IS NULL AND
2846: vtsk.status_code <> 'DELETED' AND
2847: vtsk.visit_task_id = p_task_id

Line 2854: ahl_visit_tasks_b vtsk,

2850:
2851: SELECT
2852: 'X'
2853: FROM
2854: ahl_visit_tasks_b vtsk,
2855: ahl_unit_effectivities_b aue
2856: WHERE
2857: nvl(aue.manually_planned_flag, 'N') = 'N' AND
2858: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND

Line 2869: ahl_visit_tasks_b vtsk

2865: SELECT
2866: csi.quantity
2867: FROM
2868: csi_item_instances csi,
2869: ahl_visit_tasks_b vtsk
2870: WHERE
2871: vtsk.instance_id = csi.instance_id AND
2872: vtsk.status_code <> 'DELETED' AND
2873: vtsk.visit_task_id = p_task_id;

Line 2961: ahl_visit_tasks_b

2957: FETCH c_get_instance_quantity INTO l_instance_quantity;
2958: CLOSE c_get_instance_quantity;
2959:
2960: UPDATE
2961: ahl_visit_tasks_b
2962: SET
2963: quantity = l_instance_quantity
2964: WHERE
2965: visit_task_id = p_x_prd_workorder_rec.visit_task_id;

Line 3478: ahl_visit_tasks_b vtsk

3474: IS
3475: SELECT
3476: 'X'
3477: FROM
3478: ahl_visit_tasks_b vtsk
3479: WHERE
3480: vtsk.quantity IS NULL AND
3481: vtsk.status_code <> 'DELETED' AND
3482: vtsk.visit_task_id = p_task_id

Line 3489: ahl_visit_tasks_b vtsk,

3485:
3486: SELECT
3487: 'X'
3488: FROM
3489: ahl_visit_tasks_b vtsk,
3490: ahl_unit_effectivities_b aue
3491: WHERE
3492: nvl(aue.manually_planned_flag, 'N') = 'N' AND
3493: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND

Line 3504: ahl_visit_tasks_b vtsk

3500: SELECT
3501: csi.quantity
3502: FROM
3503: csi_item_instances csi,
3504: ahl_visit_tasks_b vtsk
3505: WHERE
3506: vtsk.instance_id = csi.instance_id AND
3507: vtsk.status_code <> 'DELETED' AND
3508: vtsk.visit_task_id = p_task_id;

Line 3765: ahl_visit_tasks_b

3761: FETCH c_get_instance_quantity INTO l_instance_quantity;
3762: CLOSE c_get_instance_quantity;
3763:
3764: UPDATE
3765: ahl_visit_tasks_b
3766: SET
3767: quantity = l_instance_quantity
3768: WHERE
3769: visit_task_id = p_x_prd_workorder_rec.visit_task_id;

Line 5046: AHL_VISIT_TASKS_B VT

5042: WO.wip_entity_id wip_entity_id,
5043: WO.workorder_name workorder_name,
5044: WO.master_workorder_flag master_workorder_flag
5045: FROM AHL_WORKORDERS WO,
5046: AHL_VISIT_TASKS_B VT
5047: WHERE WO.status_code <> G_JOB_STATUS_DELETED
5048: AND WO.visit_task_id = VT.visit_task_id
5049: AND VT.task_type_code IN ( 'SUMMARY', 'UNASSOCIATED' )
5050: AND VT.unit_effectivity_id = c_unit_effectivity_id;

Line 5542: AHL_VISIT_TASKS_B VT

5538: CURSOR get_ue_mwo( c_unit_effectivity_id NUMBER ) IS
5539: SELECT WO.workorder_name workorder_name,
5540: WO.wip_entity_id wip_entity_id
5541: FROM AHL_WORKORDERS WO,
5542: AHL_VISIT_TASKS_B VT
5543: WHERE WO.visit_task_id = VT.visit_task_id
5544: AND WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,
5545: G_JOB_STATUS_COMPLETE_NC,
5546: G_JOB_STATUS_CANCELLED,

Line 5960: AHL_VISIT_TASKS_B VT

5956: WO.wip_entity_id wip_entity_id,
5957: WO.workorder_name workorder_name,
5958: WO.master_workorder_flag master_workorder_flag
5959: FROM AHL_WORKORDERS WO,
5960: AHL_VISIT_TASKS_B VT
5961: WHERE WO.status_code <> G_JOB_STATUS_DELETED
5962: AND WO.visit_task_id = VT.visit_task_id
5963: AND VT.task_type_code IN ( 'SUMMARY', 'UNASSOCIATED' )
5964: AND VT.unit_effectivity_id = c_unit_effectivity_id;

Line 5971: AHL_VISIT_TASKS_B VT

5967: -- To get the UE Workorder
5968: CURSOR get_ue_wo( c_unit_effectivity_id NUMBER ) IS
5969: SELECT WO.wip_entity_id wip_entity_id
5970: FROM AHL_WORKORDERS WO,
5971: AHL_VISIT_TASKS_B VT
5972: WHERE WO.status_code <> G_JOB_STATUS_DELETED
5973: AND WO.visit_task_id = VT.visit_task_id
5974: AND VT.task_type_code NOT IN ('SUMMARY')
5975: AND VT.unit_effectivity_id = c_unit_effectivity_id;

Line 6037: AHL_VISIT_TASKS_B VT

6033: CURSOR get_visit_mrs( c_visit_id NUMBER ) IS
6034: SELECT UE.unit_effectivity_id unit_effectivity_id,
6035: UE.object_version_number object_version_number
6036: FROM AHL_UNIT_EFFECTIVITIES_B UE,
6037: AHL_VISIT_TASKS_B VT
6038: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
6039: AND UE.manually_planned_flag = 'Y'
6040: -- Check added by balaji by balaji for bug # 4095002
6041: -- As per the update in the bug, for Manually planned UEs of type SR

Line 6067: AHL_VISIT_TASKS_B VT,

6063: CURSOR get_ue_details_for_wo( c_workorder_id NUMBER ) IS
6064: SELECT UE.unit_effectivity_id unit_effectivity_id,
6065: UE.object_version_number object_version_number
6066: FROM AHL_UNIT_EFFECTIVITIES_B UE,
6067: AHL_VISIT_TASKS_B VT,
6068: AHL_WORKORDERS WO
6069: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
6070: AND UE.manually_planned_flag = 'Y'
6071: -- Check added by balaji by balaji for bug # 4095002