APPS.AHL_PRD_NONROUTINE_PVT dependencies on AHL_VISIT_TASKS_B

Line 190: ahl_visit_tasks_b vtsk,

186: SELECT
187: wo.workorder_id,
188: wo.status_code
189: FROM
190: ahl_visit_tasks_b vtsk,
191: ahl_workorders wo,
192: ahl_unit_effectivities_b ue
193: WHERE
194: ue.cs_incident_id = p_incident_id

Line 2093: FROM AHL_VISIT_TASKS_B A,

2089: -- Begin Changes by VSUNDARA for SR Integration
2090: CURSOR default_item_org_id(p_workorder_id IN NUMBER) IS
2091: SELECT A.inventory_item_id,
2092: A.item_organization_id
2093: FROM AHL_VISIT_TASKS_B A,
2094: AHL_WORKORDERS B
2095: WHERE A.visit_task_id = B.visit_task_id
2096: AND B.workorder_id = p_workorder_id;
2097:

Line 2558: ahl_visit_tasks_b vtsk

2554: SELECT
2555: awo.workorder_id
2556: FROM
2557: ahl_workorders awo,
2558: ahl_visit_tasks_b vtsk
2559: WHERE
2560: awo.visit_task_id = vtsk.visit_task_id
2561: AND awo.master_workorder_flag = 'Y'
2562: AND vtsk.task_type_code = 'SUMMARY'

Line 2583: from ahl_visit_tasks_b

2579: --STHILAK, PIE, cursor to fetch Service Type corresponding to the NR.
2580: CURSOR c_get_nr_service_type_code (ue_id NUMBER)
2581: IS
2582: Select service_type_code
2583: from ahl_visit_tasks_b
2584: where unit_effectivity_id = ue_id;
2585:
2586: --amsriniv ER 6014567 Begin
2587: --5. cursor for retrieving the non master workorder id which is passed as to_workorder_id when calling move_intance_location

Line 2607: FROM AHL_VISIT_TASKS_B VST,

2603:
2604: --apattark added for ER #9368251
2605: CURSOR get_firm_planned_flag_csr(c_sr_id IN NUMBER) IS
2606: SELECT WIP.FIRM_PLANNED_FLAG
2607: FROM AHL_VISIT_TASKS_B VST,
2608: AHL_WORKORDERS WO,
2609: WIP_DISCRETE_JOBS WIP,
2610: AHL_UNIT_EFFECTIVITIES_B UE
2611: WHERE VST.SERVICE_REQUEST_ID = c_sr_id

Line 2627: SELECT visit_task_id FROM ahl_visit_tasks_b

2623: SELECT organization_id, status_code FROM ahl_visits_b WHERE
2624: visit_id = p_visit_id_csr;
2625: -- To find the repair batch task ID for a given instance
2626: CURSOR c_get_rprbatch_task (p_instance_id IN NUMBER, p_org_id NUMBER) IS
2627: SELECT visit_task_id FROM ahl_visit_tasks_b
2628: WHERE repair_batch_name = (AHL_CMP_UTIL_PKG.Get_Rpr_Batch_For_Inst(p_instance_id,
2629: p_org_id));
2630: CURSOR c_task_dtls (p_task_id IN NUMBER) IS
2631: SELECT instance_id FROM ahl_visit_tasks_b

Line 2631: SELECT instance_id FROM ahl_visit_tasks_b

2627: SELECT visit_task_id FROM ahl_visit_tasks_b
2628: WHERE repair_batch_name = (AHL_CMP_UTIL_PKG.Get_Rpr_Batch_For_Inst(p_instance_id,
2629: p_org_id));
2630: CURSOR c_task_dtls (p_task_id IN NUMBER) IS
2631: SELECT instance_id FROM ahl_visit_tasks_b
2632: WHERE visit_task_id = p_task_id;
2633:
2634: -- Cursor to get the RTS workorder for a repair batch
2635: CURSOR c_get_rts_wo_id(p_rpr_batch_task_id NUMBER, p_instance_id NUMBER) IS

Line 2640: (SELECT vt.visit_task_id FROM AHL_VISIT_TASKS_B vt

2636: SELECT wip_entity_id FROM ahl_workorders
2637: WHERE status_code IN ('1', '3', '6', '19', '20', '17')
2638: --unreleased, released, on-hold, parts hold and pending QA approval(open workorders)
2639: AND visit_task_id IN
2640: (SELECT vt.visit_task_id FROM AHL_VISIT_TASKS_B vt
2641: WHERE vt.cost_parent_id IS NOT NULL
2642: AND NVL(vt.return_to_supply_flag,'N') = 'Y'
2643: AND vt.instance_id = p_instance_id
2644: START WITH vt.visit_task_id = p_rpr_batch_task_id

Line 2649: SELECT repair_batch_name FROM ahl_visit_tasks_b WHERE

2645: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id
2646: );
2647: --Cursor to get the repair batch name for a given task
2648: CURSOR c_get_repair_batch_name(p_task_id IN NUMBER) IS
2649: SELECT repair_batch_name FROM ahl_visit_tasks_b WHERE
2650: visit_task_id = p_task_id
2651: AND repair_batch_name IS NOT NULL;
2652: -- Kasridha: Changes for Bug#13739171 Ends
2653: