APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISIT_TASKS_B

Line 281: ahl_visit_tasks_b vt

277: CURSOR get_route_cur (c_visit_task_id IN NUMBER)
278: IS
279: SELECT route_id
280: FROM ahl_mr_routes mr,
281: ahl_visit_tasks_b vt
282: WHERE mr.mr_route_id = vt.mr_route_id
283: AND visit_task_id = c_visit_task_id;
284: --Modifed the cursor for Bug #4104968
285: -- Cursor to get operation sequence and operation id

Line 1149: ahl_visit_tasks_b vt

1145: vt.mr_route_id,
1146: vt.instance_id,
1147: vt.start_date_time
1148: FROM ahl_visits_b vs,
1149: ahl_visit_tasks_b vt
1150: WHERE vs.visit_id = vt.visit_id
1151: AND vt.visit_task_id = C_VISIT_TASK_ID;
1152:
1153: --Get Route details

Line 1522: FROM ahl_visit_tasks_b tsk,ahl_schedule_materials asm

1518: asm.scheduled_material_id scheduled_material_id,
1519: asm.object_version_number,
1520: asm.scheduled_quantity,
1521: asm.scheduled_date
1522: FROM ahl_visit_tasks_b tsk,ahl_schedule_materials asm
1523: WHERE asm.visit_id = C_VISIT_ID
1524: AND asm.visit_task_id = tsk.visit_task_id
1525: AND tsk.status_code ='DELETED'
1526: AND asm.status <> 'DELETED';

Line 1983: AHL_VISIT_TASKS_B VTSK

1979: ASMT.scheduled_material_id schedule_material_id,
1980: decode(sign( trunc(ASMT.scheduled_date) - trunc(requested_date)), 1, ASMT.scheduled_date, null) SCHEDULED_DATE,
1981: ASMT.SCHEDULED_QUANTITY
1982: FROM AHL_SCHEDULE_MATERIALS ASMT,
1983: AHL_VISIT_TASKS_B VTSK
1984: WHERE ASMT.STATUS <> 'DELETED'
1985: AND EXISTS ( Select 1
1986: from AHL_RT_OPER_MATERIALS RTOM
1987: where RTOM.RT_OPER_MATERIAL_ID = ASMT.RT_OPER_MATERIAL_ID)

Line 3035: ahl_visit_tasks_b vt

3031: -- AnRaj: Changed the WHERE clause , for Performance improvement
3032: CURSOR get_del_mtl_req_csr(c_visit_id IN NUMBER) IS
3033: SELECT mat.scheduled_material_id
3034: FROM ahl_schedule_materials mat,
3035: ahl_visit_tasks_b vt
3036: WHERE vt.visit_id = c_visit_id
3037: AND vt.status_code = 'DELETED'
3038: AND vt.visit_task_id = mat.visit_task_id
3039: AND EXISTS (SELECT reservation_id

Line 3057: FROM ahl_visit_tasks_b

3053: SELECT organization_id
3054: FROM mtl_reservations
3055: WHERE external_source_code = 'AHL'
3056: AND demand_source_header_id in ( SELECT visit_task_id
3057: FROM ahl_visit_tasks_b
3058: WHERE visit_id = p_visit_id);
3059: --Standard local variables
3060: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Visit_Reservations';
3061: l_api_version CONSTANT NUMBER := 1.0;

Line 3095: FROM ahl_visit_tasks_b

3091: INTO l_org_count
3092: FROM mtl_reservations
3093: WHERE external_source_code = 'AHL'
3094: AND demand_source_header_id in ( SELECT visit_task_id
3095: FROM ahl_visit_tasks_b
3096: WHERE visit_id = p_visit_id);
3097:
3098: IF (l_log_statement >= l_log_current_level)THEN
3099: fnd_log.string