eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AHL_LTP_REQST_MATRL_PVT dependencies on AHL_VISIT_TASKS_B

Line 341: ahl_visit_tasks_b vt

337: CURSOR get_route_cur (c_visit_task_id IN NUMBER)
338: IS
339: SELECT route_id
340: FROM ahl_mr_routes mr,
341: ahl_visit_tasks_b vt
342: WHERE mr.mr_route_id = vt.mr_route_id
343: AND visit_task_id = c_visit_task_id;
344: --Modifed the cursor for Bug #4104968
345: -- Cursor to get operation sequence and operation id

Line 555: FROM ahl_visit_tasks_b

551: END IF;
552:
553: --Check for visit task type
554: SELECT TASK_TYPE_CODE INTO l_task_type_code
555: FROM ahl_visit_tasks_b
556: WHERE visit_task_id = p_visit_task_id;
557: --From unplanned and Unassociated
558: IF l_task_type_code IN ('UNPLANNED','UNASSOCIATED') THEN
559: l_material_request_type := 'UNPLANNED';

Line 1160: ahl_visit_tasks_b vt

1156: vt.mr_route_id,
1157: vt.instance_id,
1158: vt.start_date_time
1159: FROM ahl_visits_b vs,
1160: ahl_visit_tasks_b vt
1161: WHERE vs.visit_id = vt.visit_id
1162: AND vt.visit_task_id = C_VISIT_TASK_ID;
1163:
1164: --Get Route details

Line 1533: FROM ahl_visit_tasks_b tsk1,

1529: WHERE vs.visit_id = vt.visit_id
1530: AND vt.mr_route_id = mr.mr_route_id
1531: AND vt.unit_effectivity_id IN
1532: (SELECT tsk2.unit_effectivity_id
1533: FROM ahl_visit_tasks_b tsk1,
1534: ahl_visit_tasks_b tsk2
1535: WHERE tsk1.unit_effectivity_id = p_ue_id
1536: AND tsk1.visit_task_id = tsk2.originating_task_id)
1537: AND vs.visit_id = c_visit_id;

Line 1534: ahl_visit_tasks_b tsk2

1530: AND vt.mr_route_id = mr.mr_route_id
1531: AND vt.unit_effectivity_id IN
1532: (SELECT tsk2.unit_effectivity_id
1533: FROM ahl_visit_tasks_b tsk1,
1534: ahl_visit_tasks_b tsk2
1535: WHERE tsk1.unit_effectivity_id = p_ue_id
1536: AND tsk1.visit_task_id = tsk2.originating_task_id)
1537: AND vs.visit_id = c_visit_id;
1538:

Line 1559: FROM ahl_visit_tasks_b tsk,

1555: asm.requested_quantity,
1556: asm.uom,
1557: asm.requested_date,
1558: mtl.concatenated_segments
1559: FROM ahl_visit_tasks_b tsk,
1560: ahl_schedule_materials asm,
1561: mtl_system_items_kfv mtl
1562: WHERE asm.visit_id = C_VISIT_ID
1563: AND asm.visit_task_id = tsk.visit_task_id

Line 2130: AHL_VISIT_TASKS_B VTSK

2126: ASMT.scheduled_material_id schedule_material_id,
2127: decode(sign( trunc(ASMT.scheduled_date) - trunc(requested_date)), 1, ASMT.scheduled_date, null) SCHEDULED_DATE,
2128: ASMT.SCHEDULED_QUANTITY
2129: FROM AHL_SCHEDULE_MATERIALS ASMT,
2130: AHL_VISIT_TASKS_B VTSK
2131: WHERE ASMT.STATUS <> 'DELETED'
2132: AND EXISTS ( Select 1
2133: from AHL_RT_OPER_MATERIALS RTOM
2134: where RTOM.RT_OPER_MATERIAL_ID = ASMT.RT_OPER_MATERIAL_ID)

Line 3104: ahl_visit_tasks_b vt

3100: -- AnRaj: Changed the WHERE clause , for Performance improvement
3101: CURSOR get_del_mtl_req_csr(c_visit_id IN NUMBER) IS
3102: SELECT mat.scheduled_material_id
3103: FROM ahl_schedule_materials mat,
3104: ahl_visit_tasks_b vt
3105: WHERE vt.visit_id = c_visit_id
3106: AND vt.status_code = 'DELETED'
3107: AND vt.visit_task_id = mat.visit_task_id
3108: AND EXISTS (SELECT reservation_id

Line 3126: FROM ahl_visit_tasks_b

3122: SELECT organization_id
3123: FROM mtl_reservations
3124: WHERE external_source_code = 'AHL'
3125: AND demand_source_header_id in ( SELECT visit_task_id
3126: FROM ahl_visit_tasks_b
3127: WHERE visit_id = p_visit_id);
3128: --Standard local variables
3129: l_api_name CONSTANT VARCHAR2(30) := 'Modify_Visit_Reservations';
3130: l_api_version CONSTANT NUMBER := 1.0;

Line 3164: FROM ahl_visit_tasks_b

3160: INTO l_org_count
3161: FROM mtl_reservations
3162: WHERE external_source_code = 'AHL'
3163: AND demand_source_header_id in ( SELECT visit_task_id
3164: FROM ahl_visit_tasks_b
3165: WHERE visit_id = p_visit_id);
3166:
3167: IF (l_log_statement >= l_log_current_level)THEN
3168: fnd_log.string

Line 3576: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task, ahl_vwp_stages_b stage

3572: Cursor get_stage_task (c_visit_id IN NUMBER,
3573: c_stage_type_code IN VARCHAR2)
3574: IS
3575: SELECT task.visit_task_id, stage.planned_start_date
3576: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task, ahl_vwp_stages_b stage
3577: WHERE (assoc.stage_id = task.stage_id
3578: OR task.stage_id IS NULL)
3579: AND task.task_type_code = 'STAGE'
3580: AND task.visit_id = c_visit_id

Line 4040: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task

4036: Cursor get_stage_task (c_visit_id IN NUMBER,
4037: c_stage_type_code VARCHAR2)
4038: IS
4039: SELECT task.visit_task_id, task.start_date_time
4040: FROM ahl_visit_stage_typ_asoc assoc, ahl_visit_tasks_b task
4041: WHERE (assoc.stage_id = task.stage_id
4042: OR task.stage_id IS NULL)
4043: AND task.task_type_code = 'STAGE'
4044: AND task.visit_id = c_visit_id