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_VISITS_B

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 1382: AHL_VISITS_B vst

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;
1386:

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 2422: AHL_VISITS_B VST

2418: VST.visit_id,
2419: TSK.project_task_id,
2420: TSK.inventory_item_id
2421: FROM AHL_VISIT_TASKS_VL TSK,
2422: AHL_VISITS_B VST
2423: WHERE TSK.repair_batch_name = p_rprbatch_name_csr
2424: AND VST.visit_id = TSK.visit_id) VISIT_TASK,
2425: MTL_ITEM_LOCATIONS_KFV INRPR_LOC, CSI_ITEM_INSTANCES csi
2426: WHERE csi.inv_locator_id = INRPR_LOC.inventory_location_id

Line 3106: ahl_visits_b visit

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
3110: AND visit.visit_id = task.visit_id;