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_CMP_PVT dependencies on AHL_VISIT_TASKS_B

Line 1276: FROM AHL_VISIT_TASKS_B TSK, CSI_ITEM_INSTANCES CSI

1272: -- cursor to check the repair batch
1273: CURSOR chk_rpr_batch_csr (c_rpr_batch_name VARCHAR2,
1274: c_inv_item_id NUMBER) IS
1275: SELECT 'X'
1276: FROM AHL_VISIT_TASKS_B TSK, CSI_ITEM_INSTANCES CSI
1277: WHERE TSK.repair_batch_name = c_rpr_batch_name
1278: AND TSK.instance_id = CSI.instance_id
1279: AND CSI.inventory_item_id = c_inv_item_id
1280: AND TSK.status_code NOT IN ('CANCELLED', 'CLOSED', 'DELETED');

Line 1299: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

1295: PRT.task_id project_task_id,
1296: PRT.task_number project_task_number,
1297: VST.comp_planning_loc_id,
1298: VST.comp_inrepair_loc_id
1299: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
1300: PA_PROJECTS_ALL PRJ, PA_TASKS PRT
1301: WHERE TSK.visit_task_id = c_visit_task_id
1302: AND VST.visit_id = TSK.visit_id
1303: AND PRJ.project_id = VST.project_id

Line 1330: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

1326: FROM MTL_ITEM_LOCATIONS
1327: WHERE physical_location_id = VST.comp_inrepair_loc_id
1328: AND project_id = VST.project_id
1329: AND task_id = AHL_VWP_PROJ_PROD_PVT.Get_RB_Transaction_Task(VST.project_id,TSK.project_task_id,VST.visit_id)) inrepair_subinv
1330: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
1331: MTL_ITEM_LOCATIONS MTLP
1332: WHERE TSK.repair_batch_name = c_rpr_batch_name
1333: AND VST.visit_id = TSK.visit_id
1334: AND MTLP.physical_location_id = VST.comp_planning_loc_id

Line 1364: FROM AHL_VISIT_TASKS_B

1360: -- pdoki modified for Bug 13722071
1361: -- cursor to get all the applicable tasks for update in a given repair batch's scope
1362: CURSOR get_applcbl_tasks_csr (c_rpr_batch_name VARCHAR2) IS
1363: SELECT visit_task_id
1364: FROM AHL_VISIT_TASKS_B
1365: WHERE repair_batch_name = c_rpr_batch_name
1366: UNION ALL
1367: SELECT vts.visit_task_id
1368: FROM AHL_VISIT_TASKS_B vts,

Line 1368: FROM AHL_VISIT_TASKS_B vts,

1364: FROM AHL_VISIT_TASKS_B
1365: WHERE repair_batch_name = c_rpr_batch_name
1366: UNION ALL
1367: SELECT vts.visit_task_id
1368: FROM AHL_VISIT_TASKS_B vts,
1369: AHL_WORKORDERS wo
1370: WHERE vts.status_code NOT IN ('CANCELLED', 'CLOSED', 'DELETED')
1371: AND wo.visit_task_id = vts.visit_task_id
1372: AND wo.status_code NOT IN ('7','12','22' ) -- Cancelled,Closed,Deleted

Line 1374: FROM AHL_VISIT_TASKS_B

1370: WHERE vts.status_code NOT IN ('CANCELLED', 'CLOSED', 'DELETED')
1371: AND wo.visit_task_id = vts.visit_task_id
1372: AND wo.status_code NOT IN ('7','12','22' ) -- Cancelled,Closed,Deleted
1373: START WITH vts.cost_parent_id = ( SELECT visit_task_id
1374: FROM AHL_VISIT_TASKS_B
1375: WHERE repair_batch_name = c_rpr_batch_name)
1376: CONNECT BY vts.cost_parent_id = PRIOR vts.visit_task_id;
1377:
1378: -- cursor to check if the repair batch belongs to a visit that is past dated.

Line 1381: FROM AHL_VISIT_TASKS_B tsk,

1377:
1378: -- cursor to check if the repair batch belongs to a visit that is past dated.
1379: CURSOR Check_Past_Dated_Visit(c_rpr_batch_name VARCHAR2) IS
1380: SELECT 'x'
1381: FROM AHL_VISIT_TASKS_B tsk,
1382: AHL_VISITS_B vst
1383: WHERE vst.visit_id = tsk.visit_id
1384: AND tsk.repair_batch_name = c_rpr_batch_name
1385: AND NVL(vst.close_date_time, SYSDATE+1) < SYSDATE;

Line 1702: UPDATE AHL_VISIT_TASKS_B SET

1698: l_visit_task_det_csr.visit_task_number;
1699:
1700: -- 3) Update the task quantity, repair batch name, target_qty, ret_serviceable_qty and ret_unserviceable_qty
1701: -- and visit task name in the TL table (it will be replaced in the UI later, if needed)
1702: UPDATE AHL_VISIT_TASKS_B SET
1703: target_qty = p_repair_qty,
1704: quantity = p_repair_qty,
1705: repair_batch_name = p_x_dst_rpr_batch_name,
1706: ret_serviceable_qty = NULL,

Line 1838: UPDATE AHL_VISIT_TASKS_B SET

1834: FETCH get_locator_inst_id_csr INTO l_locator_inst_id;
1835: CLOSE get_locator_inst_id_csr;
1836:
1837: -- 2) Update repair batch's (task's) instance
1838: UPDATE AHL_VISIT_TASKS_B SET
1839: instance_id = l_locator_inst_id
1840: WHERE repair_batch_name = p_x_dst_rpr_batch_name;
1841: END IF;
1842: ELSE

Line 1861: UPDATE AHL_VISIT_TASKS_B SET

1857:
1858: -- update the tasks
1859: IF (l_task_id_tbl.COUNT > 0) THEN
1860: FOR i IN l_task_id_tbl.FIRST..l_task_id_tbl.LAST LOOP
1861: UPDATE AHL_VISIT_TASKS_B SET
1862: quantity = l_locator_inst_qty
1863: WHERE visit_task_id = l_task_id_tbl(i);
1864: END LOOP;
1865: END IF;

Line 1888: UPDATE AHL_VISIT_TASKS_B SET

1884:
1885: -- update the tasks
1886: IF (l_task_id_tbl.COUNT > 0) THEN
1887: FOR i IN l_task_id_tbl.FIRST..l_task_id_tbl.LAST LOOP
1888: UPDATE AHL_VISIT_TASKS_B SET
1889: quantity = l_locator_inst_qty
1890: WHERE visit_task_id = l_task_id_tbl(i);
1891: END LOOP;
1892: END IF;

Line 2001: FROM AHL_VISIT_TASKS_B vt

1997: SELECT wo.visit_task_id,wo.workorder_id,wo.workorder_name,wo.status_code
1998: FROM ahl_workorders wo
1999: WHERE wo.visit_task_id in
2000: ( SELECT vt.visit_task_id
2001: FROM AHL_VISIT_TASKS_B vt
2002: START WITH vt.visit_task_id = c_repair_batch_id
2003: CONNECT BY PRIOR VT.VISIT_TASK_ID = VT.COST_PARENT_ID );
2004:
2005: CURSOR get_wip_entity(c_repair_batch_id NUMBER)

Line 2012: FROM AHL_VISIT_TASKS_B vt

2008: FROM ahl_workorders wo
2009: WHERE wo.STATUS_CODE <> '7'
2010: AND wo.visit_task_id IN
2011: ( SELECT vt.visit_task_id
2012: FROM AHL_VISIT_TASKS_B vt
2013: START WITH vt.visit_task_id = c_repair_batch_id
2014: CONNECT BY PRIOR VT.VISIT_TASK_ID = VT.COST_PARENT_ID );
2015:
2016: l_wip_entity_rec get_wip_entity%ROWTYPE;

Line 2023: FROM AHL_VISIT_TASKS_B

2019: -- To find visit Id
2020: CURSOR get_batch_details (c_repair_batch_id NUMBER)
2021: IS
2022: SELECT *
2023: FROM AHL_VISIT_TASKS_B
2024: WHERE visit_task_id = c_repair_batch_id;
2025:
2026: l_batch_dtl_rec get_batch_details%ROWTYPE;
2027: l_batch_qty NUMBER;

Line 2163: UPDATE ahl_visit_tasks_b

2159: fnd_log.string(fnd_log.level_statement,L_DEBUG,'Updating the actual cost of WO to - '||l_actual_cost);
2160: END IF;
2161:
2162: -- Update with actual cost
2163: UPDATE ahl_visit_tasks_b
2164: SET actual_cost = l_actual_cost
2165: WHERE visit_task_id = l_wip_entity_rec.visit_task_id;
2166:
2167: END IF;

Line 2179: /* UPDATE ahl_visit_tasks_b

2175: RAISE FND_API.G_EXC_ERROR;
2176: END IF;
2177:
2178: -- Update Repair Batch and its child task Statuses to Closed.
2179: /* UPDATE ahl_visit_tasks_b
2180: SET status_code = 'CLOSED'
2181: WHERE visit_task_id IN ( SELECT vt.visit_task_id
2182: FROM AHL_VISIT_TASKS_B vt
2183: START WITH vt.visit_task_id = p_repair_batch_id

Line 2182: FROM AHL_VISIT_TASKS_B vt

2178: -- Update Repair Batch and its child task Statuses to Closed.
2179: /* UPDATE ahl_visit_tasks_b
2180: SET status_code = 'CLOSED'
2181: WHERE visit_task_id IN ( SELECT vt.visit_task_id
2182: FROM AHL_VISIT_TASKS_B vt
2183: START WITH vt.visit_task_id = p_repair_batch_id
2184: CONNECT BY PRIOR VT.VISIT_TASK_ID = VT.COST_PARENT_ID ); */
2185:
2186: -- Update Repair Batch Summary task status to Closed

Line 2187: UPDATE ahl_visit_tasks_b

2183: START WITH vt.visit_task_id = p_repair_batch_id
2184: CONNECT BY PRIOR VT.VISIT_TASK_ID = VT.COST_PARENT_ID ); */
2185:
2186: -- Update Repair Batch Summary task status to Closed
2187: UPDATE ahl_visit_tasks_b
2188: SET status_code = 'CLOSED'
2189: WHERE visit_task_id = p_repair_batch_id ;
2190:
2191: ELSE

Line 2337: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

2333: PRT.task_id project_task_id,
2334: PRT.task_number project_task_number,
2335: VST.comp_inrepair_loc_id,
2336: VST.comp_planning_loc_id
2337: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
2338: PA_PROJECTS_ALL PRJ, PA_TASKS PRT
2339: WHERE TSK.repair_batch_name = p_rpr_batch_name_csr
2340: AND VST.visit_id = TSK.visit_id
2341: AND PRJ.project_id = VST.project_id

Line 2352: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

2348: -- for a given repair batch
2349: CURSOR get_src_locator_id_csr (p_rpr_batch_name_csr VARCHAR2) IS
2350: SELECT MTL.inventory_location_id,
2351: MTL.subinventory_code
2352: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
2353: MTL_ITEM_LOCATIONS MTL
2354: WHERE TSK.repair_batch_name = p_rpr_batch_name_csr
2355: AND VST.visit_id = TSK.visit_id
2356: AND MTL.physical_location_id = VST.comp_planning_loc_id

Line 2366: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

2362: -- for a given repair batch
2363: CURSOR get_inrepair_locator_id_csr (p_rpr_batch_name_csr VARCHAR2) IS
2364: SELECT MTL.inventory_location_id,
2365: MTL.subinventory_code
2366: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
2367: MTL_ITEM_LOCATIONS MTL
2368: WHERE TSK.repair_batch_name = p_rpr_batch_name_csr
2369: AND VST.visit_id = TSK.visit_id
2370: AND MTL.physical_location_id = VST.comp_inrepair_loc_id

Line 2403: FROM AHL_VISIT_TASKS_B vt

2399: WHERE status_code IN ('1', '3', '6', '19', '20', '17')
2400: --unreleased, released, on-hold, parts hold and pending QA approval(open workorders)
2401: AND visit_task_id IN
2402: (SELECT vt.visit_task_id
2403: FROM AHL_VISIT_TASKS_B vt
2404: WHERE instance_id = p_instance_id_csr
2405: START WITH vt.visit_task_id =
2406: (SELECT visit_task_id
2407: FROM ahl_visit_tasks_b

Line 2407: FROM ahl_visit_tasks_b

2403: FROM AHL_VISIT_TASKS_B vt
2404: WHERE instance_id = p_instance_id_csr
2405: START WITH vt.visit_task_id =
2406: (SELECT visit_task_id
2407: FROM ahl_visit_tasks_b
2408: WHERE repair_batch_name = p_repair_batch_csr
2409: )
2410: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id
2411: );

Line 2521: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task

2517: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Updating tasks in repair batch to new instance');
2518: END IF;
2519: IF (l_log_statement >= l_log_current_level) THEN
2520: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Before updating WOs');
2521: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2522: WHERE
2523: task.visit_task_id = wo.visit_task_id
2524: and task.instance_id = p_instance_id;
2525: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);

Line 2534: UPDATE ahl_visit_tasks_b SET instance_id = l_new_instance_id WHERE

2530: FETCH get_wip_entity_ids_csr BULK COLLECT INTO l_wip_entity_tbl;
2531: CLOSE get_wip_entity_ids_csr;
2532:
2533: -- 2) Update all the tasks in the repair batch with the new instance id
2534: UPDATE ahl_visit_tasks_b SET instance_id = l_new_instance_id WHERE
2535: visit_id = (SELECT visit_id FROM ahl_visit_tasks_b
2536: WHERE repair_batch_name = p_repair_batch_name)
2537: AND instance_id = p_instance_id;
2538:

Line 2535: visit_id = (SELECT visit_id FROM ahl_visit_tasks_b

2531: CLOSE get_wip_entity_ids_csr;
2532:
2533: -- 2) Update all the tasks in the repair batch with the new instance id
2534: UPDATE ahl_visit_tasks_b SET instance_id = l_new_instance_id WHERE
2535: visit_id = (SELECT visit_id FROM ahl_visit_tasks_b
2536: WHERE repair_batch_name = p_repair_batch_name)
2537: AND instance_id = p_instance_id;
2538:
2539: IF (l_log_statement >= l_log_current_level) THEN

Line 2541: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task

2537: AND instance_id = p_instance_id;
2538:
2539: IF (l_log_statement >= l_log_current_level) THEN
2540: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'After updating WOs');
2541: SELECT COUNT(wo.visit_task_id) INTO l_open_wo_count FROM ahl_workorders wo, ahl_visit_tasks_b task
2542: WHERE
2543: task.visit_task_id = wo.visit_task_id
2544: and task.instance_id = p_instance_id;
2545: FND_LOG.string(l_log_statement, L_DEBUG_KEY,'Openworkorders for the instance::' || l_open_wo_count);

Line 2701: UPDATE ahl_visit_tasks_b SET instance_id = l_locator_inst_id WHERE

2697: || l_locator_inst_id);
2698: END IF;
2699:
2700: -- Update all the tasks in the repair batch with the new locator instance id
2701: UPDATE ahl_visit_tasks_b SET instance_id = l_locator_inst_id WHERE
2702: visit_id = (SELECT visit_id FROM ahl_visit_tasks_b
2703: WHERE repair_batch_name = p_repair_batch_name)
2704: AND instance_id = l_new_instance_id;
2705:

Line 2702: visit_id = (SELECT visit_id FROM ahl_visit_tasks_b

2698: END IF;
2699:
2700: -- Update all the tasks in the repair batch with the new locator instance id
2701: UPDATE ahl_visit_tasks_b SET instance_id = l_locator_inst_id WHERE
2702: visit_id = (SELECT visit_id FROM ahl_visit_tasks_b
2703: WHERE repair_batch_name = p_repair_batch_name)
2704: AND instance_id = l_new_instance_id;
2705:
2706: IF (l_log_statement >= l_log_current_level) THEN

Line 3105: ahl_workorders wo, ahl_visit_tasks_b task,

3101: SELECT wo.workorder_id,
3102: task.inventory_item_id, visit.organization_id,
3103: wo.status_code
3104: FROM
3105: ahl_workorders wo, ahl_visit_tasks_b task,
3106: ahl_visits_b visit
3107: WHERE
3108: wo.wip_entity_id = p_wip_entity_id_csr
3109: AND task.visit_task_id = wo.visit_task_id

Line 3433: FROM AHL_VISIT_TASKS_B vt

3429: FROM AHL_WORKORDERS
3430: WHERE status_code IN ('1', '3', '6', '17', '19', '20' ) -- unreleased, released, on-hold, draft, parts hold, pending QA (Open WO Statuses)
3431: AND visit_task_id IN
3432: (SELECT visit_task_id
3433: FROM AHL_VISIT_TASKS_B vt
3434: WHERE vt.cost_parent_id IS NOT NULL
3435: AND vt.instance_id = c_ins_id
3436: START WITH vt.visit_task_id = c_repair_batch_id
3437: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id );

Line 3449: FROM AHL_VISIT_TASKS_B vt

3445: WHERE WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID
3446: and wo.status_code NOT IN ('7','12','17','22' ) -- Cancelled,Closed,Draft and Deleted
3447: AND VISIT_TASK_ID IN
3448: ( SELECT vt.visit_task_id
3449: FROM AHL_VISIT_TASKS_B vt
3450: WHERE vt.cost_parent_id IS NOT NULL
3451: AND nvl(vt.return_to_supply_flag,'N') = 'Y'
3452: AND vt.instance_id = nvl(c_ins_id,vt.instance_id)
3453: START WITH vt.visit_task_id = (SELECT visit_task_id

Line 3454: FROM AHL_VISIT_TASKS_B

3450: WHERE vt.cost_parent_id IS NOT NULL
3451: AND nvl(vt.return_to_supply_flag,'N') = 'Y'
3452: AND vt.instance_id = nvl(c_ins_id,vt.instance_id)
3453: START WITH vt.visit_task_id = (SELECT visit_task_id
3454: FROM AHL_VISIT_TASKS_B
3455: WHERE REPAIR_BATCH_NAME = C_REPAIR_BATCH)
3456: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id );
3457:
3458: l_rts_wo_dtls_rec Get_RTS_WO_Details%ROWTYPE;

Line 3487: FROM AHL_VISIT_TASKS_B vt

3483: -- pdoki added for Bug 13721975, Start.
3484: CURSOR Get_Child_Summary_Tasks( c_repair_batch VARCHAR2, c_ins_id NUMBER)
3485: IS
3486: SELECT vt.visit_task_id
3487: FROM AHL_VISIT_TASKS_B vt
3488: WHERE vt.cost_parent_id IS NOT NULL
3489: AND vt.originating_task_id IS NULL
3490: AND vt.task_type_code = 'SUMMARY'
3491: AND vt.status_code = 'PLANNING'

Line 3494: FROM AHL_VISIT_TASKS_B

3490: AND vt.task_type_code = 'SUMMARY'
3491: AND vt.status_code = 'PLANNING'
3492: AND vt.instance_id = c_ins_id
3493: START WITH vt.visit_task_id = ( SELECT visit_task_id
3494: FROM AHL_VISIT_TASKS_B
3495: WHERE repair_batch_name = c_repair_batch )
3496: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id;
3497: -- pdoki added for Bug 13721975, End.
3498:

Line 3632: UPDATE AHL_VISIT_TASKS_B

3628: LOOP
3629: FETCH Get_Open_Workorders INTO l_workorder_name, l_visit_task_id;
3630: EXIT WHEN Get_Open_Workorders%NOTFOUND;
3631:
3632: UPDATE AHL_VISIT_TASKS_B
3633: SET quantity = l_remaining_qty
3634: WHERE visit_task_id = l_visit_task_id ;
3635:
3636: IF (l_log_statement >= l_log_current_level) THEN

Line 3644: UPDATE AHL_VISIT_TASKS_B

3640: END IF;
3641:
3642: -- Based on the Return Condition, update Return Serviceable/Return Un-Serviceable Qty fields of the Repair Batch summary task.
3643: IF ( p_x_ahl_mtlrtn_tbl(i).Return_Condition = G_AHL_UNSERVICEABLE_CONDITION OR p_x_ahl_mtlrtn_tbl(i).Return_Condition = G_AHL_MRB_CONDITION ) THEN
3644: UPDATE AHL_VISIT_TASKS_B
3645: SET RET_UNSERVICEABLE_QTY = NVL(RET_UNSERVICEABLE_QTY,0) + P_X_AHL_MTLRTN_TBL(I).RETURN_QTY
3646: WHERE visit_task_id = p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id;
3647:
3648: ELSE

Line 3649: UPDATE AHL_VISIT_TASKS_B

3645: SET RET_UNSERVICEABLE_QTY = NVL(RET_UNSERVICEABLE_QTY,0) + P_X_AHL_MTLRTN_TBL(I).RETURN_QTY
3646: WHERE visit_task_id = p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id;
3647:
3648: ELSE
3649: UPDATE AHL_VISIT_TASKS_B
3650: SET RET_SERVICEABLE_QTY = NVL(RET_SERVICEABLE_QTY,0) + P_X_AHL_MTLRTN_TBL(I).RETURN_QTY
3651: WHERE visit_task_id = p_x_ahl_mtlrtn_tbl(i).Repair_Batch_Id;
3652:
3653: END IF;