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

Line 54: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

50: -- cursor to get the repair batch name in the given visit, whose locator holds the given instance
51: CURSOR get_rpr_batch_csr (c_visit_id NUMBER,
52: c_instance_id NUMBER) IS
53: SELECT TSK.repair_batch_name
54: FROM AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
55: CSI_ITEM_INSTANCES CSI, MTL_ITEM_LOCATIONS MTL
56: WHERE TSK.visit_id = c_visit_id
57: AND VST.visit_id = TSK.visit_id
58: AND (

Line 466: FROM AHL_VISIT_TASKS_B vt

462: FROM AHL_WORKORDERS
463: WHERE status_code NOT IN ('7','12','17','22' ) -- Cancelled,Closed,Draft and Deleted
464: AND visit_task_id IN
465: (SELECT vt.visit_task_id
466: FROM AHL_VISIT_TASKS_B vt
467: WHERE vt.cost_parent_id IS NOT NULL
468: AND nvl(vt.return_to_supply_flag,'N') = 'Y'
469: AND vt.instance_id = nvl(c_ins_id,vt.instance_id)
470: START WITH vt.visit_task_id = (SELECT visit_task_id

Line 471: FROM AHL_VISIT_TASKS_B

467: WHERE vt.cost_parent_id IS NOT NULL
468: AND nvl(vt.return_to_supply_flag,'N') = 'Y'
469: AND vt.instance_id = nvl(c_ins_id,vt.instance_id)
470: START WITH vt.visit_task_id = (SELECT visit_task_id
471: FROM AHL_VISIT_TASKS_B
472: WHERE repair_batch_name = c_repair_batch)
473: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id );
474:
475:

Line 518: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

514: -- Retrieves Planning Locator Quantity
515: SELECT NVL(SUM(CII.quantity),0)
516: INTO l_planning_qty
517: FROM CSI_ITEM_INSTANCES CII,
518: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
519: MTL_ITEM_LOCATIONS MTL
520: WHERE TSK.repair_batch_name = p_repair_batch
521: AND VST.visit_id = TSK.visit_id
522: AND MTL.physical_location_id = VST.comp_planning_loc_id

Line 538: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,

534: -- Retrieves In-Repair Locator Quantity
535: SELECT NVL(SUM(CII.quantity),0)
536: INTO l_inrepair_qty
537: FROM CSI_ITEM_INSTANCES CII,
538: AHL_VISIT_TASKS_B TSK, AHL_VISITS_B VST,
539: MTL_ITEM_LOCATIONS MTL
540: WHERE TSK.repair_batch_name = p_repair_batch
541: AND VST.visit_id = TSK.visit_id
542: AND MTL.physical_location_id = VST.comp_inrepair_loc_id

Line 586: FROM AHL_VISIT_TASKS_B vt

582:
583: CURSOR Get_Task_Details(c_repair_batch varchar2)
584: IS
585: SELECT vt.visit_task_id
586: FROM AHL_VISIT_TASKS_B vt
587: WHERE VT.COST_PARENT_ID IS NOT NULL
588: START WITH vt.visit_task_id = ( SELECT visit_task_id
589: FROM AHL_VISIT_TASKS_B
590: WHERE REPAIR_BATCH_NAME = C_REPAIR_BATCH )

Line 589: FROM AHL_VISIT_TASKS_B

585: SELECT vt.visit_task_id
586: FROM AHL_VISIT_TASKS_B vt
587: WHERE VT.COST_PARENT_ID IS NOT NULL
588: START WITH vt.visit_task_id = ( SELECT visit_task_id
589: FROM AHL_VISIT_TASKS_B
590: WHERE REPAIR_BATCH_NAME = C_REPAIR_BATCH )
591: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id;
592:
593: CURSOR Get_Ins_Qty(C_VISIT_TASK_ID NUMBER)

Line 701: l_rpr_batch AHL_VISIT_TASKS_B.REPAIR_BATCH_NAME%TYPE;

697: FUNCTION Get_Repair_Batch (
698: p_child_task_id IN NUMBER
699: ) RETURN VARCHAR2
700: IS
701: l_rpr_batch AHL_VISIT_TASKS_B.REPAIR_BATCH_NAME%TYPE;
702:
703: BEGIN
704:
705: SELECT REPAIR_BATCH_NAME

Line 707: FROM AHL_VISIT_TASKS_B

703: BEGIN
704:
705: SELECT REPAIR_BATCH_NAME
706: INTO l_rpr_batch
707: FROM AHL_VISIT_TASKS_B
708: WHERE cost_parent_id IS NULL
709: AND repair_batch_name IS NOT NULL
710: START WITH visit_task_id = p_child_task_id
711: CONNECT BY PRIOR cost_parent_id = visit_task_id ;

Line 759: SELECT SUM(task.quantity) plan_qty, task.instance_id FROM ahl_visit_tasks_b task,

755: p_org_id NUMBER,
756: p_start_date DATE,
757: p_end_date DATE,
758: p_comp_visit_flag VARCHAR2) IS
759: SELECT SUM(task.quantity) plan_qty, task.instance_id FROM ahl_visit_tasks_b task,
760: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ
761: WHERE
762: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
763: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID

Line 785: SELECT 'Y' FROM ahl_visit_tasks_b task,

781: CURSOR c_is_rts_exist(p_instance_id NUMBER,
782: p_start_date DATE,
783: p_end_date DATE,
784: p_comp_visit_flag VARCHAR2) IS
785: SELECT 'Y' FROM ahl_visit_tasks_b task,
786: ahl_workorders wo,WIP_DISCRETE_JOBS WDJ
787: WHERE
788: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
789: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID

Line 870: SELECT SUM(task.quantity) sched_qty FROM ahl_visit_tasks_b task,

866: p_org_id NUMBER,
867: p_start_date DATE,
868: p_end_date DATE,
869: p_comp_visit_flag VARCHAR2) IS
870: SELECT SUM(task.quantity) sched_qty FROM ahl_visit_tasks_b task,
871: ahl_workorders wo,ahl_visits_b visit,WIP_DISCRETE_JOBS WDJ
872: WHERE
873: wo.VISIT_TASK_ID = task.VISIT_TASK_ID
874: AND WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID

Line 943: FROM AHL_VISIT_TASKS_B vt

939: FROM AHL_WORKORDERS
940: WHERE status_code NOT IN ('4','12','7','5','17' ) -- Complete,Closed,Cancelled,Complete-No-Charge and Draft
941: AND visit_task_id IN
942: (SELECT visit_task_id
943: FROM AHL_VISIT_TASKS_B vt
944: WHERE vt.cost_parent_id IS NOT NULL
945: AND vt.instance_id = nvl(c_ins_id,vt.instance_id)
946: START WITH vt.visit_task_id = (SELECT visit_task_id
947: FROM AHL_VISIT_TASKS_B

Line 947: FROM AHL_VISIT_TASKS_B

943: FROM AHL_VISIT_TASKS_B vt
944: WHERE vt.cost_parent_id IS NOT NULL
945: AND vt.instance_id = nvl(c_ins_id,vt.instance_id)
946: START WITH vt.visit_task_id = (SELECT visit_task_id
947: FROM AHL_VISIT_TASKS_B
948: WHERE repair_batch_name = c_repair_batch)
949: CONNECT BY PRIOR vt.visit_task_id = vt.cost_parent_id );
950:
951:

Line 998: ahl_visit_tasks_b task WHERE repair_batch_name = p_repair_batch_csr;

994:
995: --Cursor to fetch the serviceable and unserviceable quantities for a given repair batch
996: CURSOR rpr_batch_quantities_csr(p_repair_batch_csr VARCHAR2) IS
997: SELECT nvl(ret_serviceable_qty, 0) serv_qty, nvl(ret_unserviceable_qty,0) unserv_qty FROM
998: ahl_visit_tasks_b task WHERE repair_batch_name = p_repair_batch_csr;
999:
1000: BEGIN
1001:
1002: