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

Line 1547: FROM AHL_VISIT_TASKS_B

1543: END IF;
1544:
1545: SELECT COUNT(*)
1546: INTO l_dummy_ctr
1547: FROM AHL_VISIT_TASKS_B
1548: WHERE visit_task_id=p_prd_workorder_rec.visit_task_id;
1549:
1550: IF l_dummy_ctr=0 THEN
1551: FND_MESSAGE.SET_NAME('AHL','AHL_PRD_visit_task_invalid');

Line 1952: ahl_visit_tasks_b vtsk,

1948: IS
1949: SELECT
1950: nvl(vtsk.quantity, 1)
1951: FROM
1952: ahl_visit_tasks_b vtsk,
1953: ahl_workorders awo
1954: WHERE
1955: vtsk.visit_task_id = awo.visit_task_id AND
1956: awo.workorder_id = p_workorder_id;

Line 2166: ahl_visit_tasks_b vtsk,

2162: IS
2163: SELECT
2164: nvl(vtsk.quantity, 1)
2165: FROM
2166: ahl_visit_tasks_b vtsk,
2167: ahl_workorders awo
2168: WHERE
2169: vtsk.visit_task_id = awo.visit_task_id AND
2170: awo.workorder_id = p_workorder_id;

Line 3321: AHL_VISIT_TASKS_B VTSK,

3317: SELECT
3318: CSIA.summary, -- sr summary
3319: CSIT.name -- sr type attribute
3320: FROM
3321: AHL_VISIT_TASKS_B VTSK,
3322: AHL_UNIT_EFFECTIVITIES_B UE,
3323: CS_INCIDENTS_ALL CSIA,
3324: CS_INCIDENT_TYPES_VL CSIT
3325: WHERE

Line 3752: ahl_visit_tasks_b vtsk

3748: IS
3749: SELECT
3750: 'X'
3751: FROM
3752: ahl_visit_tasks_b vtsk
3753: WHERE
3754: vtsk.quantity IS NULL AND
3755: vtsk.status_code <> 'DELETED' AND
3756: vtsk.visit_task_id = p_task_id

Line 3763: ahl_visit_tasks_b vtsk,

3759:
3760: SELECT
3761: 'X'
3762: FROM
3763: ahl_visit_tasks_b vtsk,
3764: ahl_unit_effectivities_b aue
3765: WHERE
3766: nvl(aue.manually_planned_flag, 'N') = 'N' AND
3767: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND

Line 3778: ahl_visit_tasks_b vtsk

3774: SELECT
3775: csi.quantity
3776: FROM
3777: csi_item_instances csi,
3778: ahl_visit_tasks_b vtsk
3779: WHERE
3780: vtsk.instance_id = csi.instance_id AND
3781: vtsk.status_code <> 'DELETED' AND
3782: vtsk.visit_task_id = p_task_id;

Line 3788: FROM AHL_VISIT_TASKS_B

3784: -- MANESING::NR Analysis, 03-Jun-2011, added cursor to check whether the Workorder is a Stage Workorder
3785: CURSOR check_stg_workorder_csr (c_visit_task_id NUMBER)
3786: IS
3787: SELECT 'Y'
3788: FROM AHL_VISIT_TASKS_B
3789: WHERE visit_task_id = c_visit_task_id
3790: AND task_type_code = 'STAGE';
3791: --
3792:

Line 3832: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_VISIT_INST_ROUTINGS RTNG

3828: --Cursor to get instance routing attached to workorder instance.
3829: CURSOR Get_Wo_Inst_Rtng(p_workorder_id IN NUMBER) IS
3830: SELECT RTNG.INST_ROUTING_CODE INSTANCE_RTNG
3831: FROM
3832: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK, AHL_VISIT_INST_ROUTINGS RTNG
3833: WHERE
3834: WO.WORKORDER_ID = p_workorder_id
3835: AND WO.VISIT_TASK_ID = TSK.VISIT_TASK_ID
3836: AND TSK.INSTANCE_ID IS NOT NULL

Line 3924: ahl_visit_tasks_b

3920: FETCH c_get_instance_quantity INTO l_instance_quantity;
3921: CLOSE c_get_instance_quantity;
3922:
3923: UPDATE
3924: ahl_visit_tasks_b
3925: SET
3926: quantity = l_instance_quantity
3927: WHERE
3928: visit_task_id = p_x_prd_workorder_rec.visit_task_id;

Line 4598: ahl_visit_tasks_b vtsk

4594: IS
4595: SELECT
4596: 'X'
4597: FROM
4598: ahl_visit_tasks_b vtsk
4599: WHERE
4600: vtsk.quantity IS NULL AND
4601: vtsk.status_code <> 'DELETED' AND
4602: vtsk.visit_task_id = p_task_id

Line 4609: ahl_visit_tasks_b vtsk,

4605:
4606: SELECT
4607: 'X'
4608: FROM
4609: ahl_visit_tasks_b vtsk,
4610: ahl_unit_effectivities_b aue
4611: WHERE
4612: nvl(aue.manually_planned_flag, 'N') = 'N' AND
4613: vtsk.unit_effectivity_id = aue.unit_effectivity_id AND

Line 4624: ahl_visit_tasks_b vtsk

4620: SELECT
4621: csi.quantity
4622: FROM
4623: csi_item_instances csi,
4624: ahl_visit_tasks_b vtsk
4625: WHERE
4626: vtsk.instance_id = csi.instance_id AND
4627: vtsk.status_code <> 'DELETED' AND
4628: vtsk.visit_task_id = p_task_id;

Line 4744: AHL_VISIT_TASKS_B AVT,

4740: WDJ.SCHEDULED_COMPLETION_DATE
4741: FROM AHL_MR_HEADERS_B AMH,
4742: AHL_WORKORDERS AW,
4743: AHL_VISITS_B AV,
4744: AHL_VISIT_TASKS_B AVT,
4745: wip_discrete_jobs wdj
4746: WHERE AW.VISIT_TASK_ID = AVT.VISIT_TASK_ID
4747: AND AV.VISIT_ID = AVT.VISIT_ID
4748: AND AVT.MR_ID = AMH.MR_HEADER_ID (+)

Line 4760: AHL_VISIT_TASKS_B AVT,

4756: CURSOR GET_WO_MATERIAL_REQ_DETAILS(P_WORKORDER_ID NUMBER)
4757: IS
4758: SELECT ASM.AOG_FLAG
4759: FROM AHL_SCHEDULE_MATERIALS ASM,
4760: AHL_VISIT_TASKS_B AVT,
4761: AHL_WORKORDERS AW
4762: WHERE ASM.VISIT_TASK_ID = AVT.VISIT_TASK_ID
4763: AND AW.VISIT_TASK_ID = AVT.VISIT_TASK_ID
4764: AND ASM.AOG_FLAG = 'Y'

Line 5071: ahl_visit_tasks_b

5067: FETCH c_get_instance_quantity INTO l_instance_quantity;
5068: CLOSE c_get_instance_quantity;
5069:
5070: UPDATE
5071: ahl_visit_tasks_b
5072: SET
5073: quantity = l_instance_quantity
5074: WHERE
5075: visit_task_id = p_x_prd_workorder_rec.visit_task_id;

Line 6280: FROM AHL_VISIT_TASKS_B

6276: AS
6277: --MANESING::NR Analysis, 03-Jun-2011, added cursor for fetching visit task details
6278: CURSOR get_task_details_csr (c_visit_task_id NUMBER) IS
6279: SELECT mr_id, unit_effectivity_id
6280: FROM AHL_VISIT_TASKS_B
6281: WHERE visit_task_id = c_visit_task_id;
6282:
6283: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_JOBS';
6284: l_api_version CONSTANT NUMBER := 1.0;

Line 6853: AHL_VISIT_TASKS_B AVTB

6849: SELECT STAGE.stage_id
6850:
6851: FROM AHL_VISIT_STAGE_TYP_ASOC ASOC,
6852: AHL_VWP_STAGES_B STAGE,
6853: AHL_VISIT_TASKS_B AVTB
6854:
6855: WHERE ASOC.stage_type_code = c_stage_type_code
6856: AND ASOC.stage_id = STAGE.stage_id
6857: AND STAGE.visit_id = c_visit_id

Line 6876: FROM AHL_VISIT_TASKS_B AVTB,

6872: AVB.organization_id,
6873: AVB.department_id,
6874: BOMD.description department_name
6875:
6876: FROM AHL_VISIT_TASKS_B AVTB,
6877: AHL_WORKORDERS AHLW,
6878: AHL_VISITS_B AVB,
6879: BOM_DEPARTMENTS BOMD
6880:

Line 7475: AHL_VISIT_TASKS_B VT

7471: WO.wip_entity_id wip_entity_id,
7472: WO.workorder_name workorder_name,
7473: WO.master_workorder_flag master_workorder_flag
7474: FROM AHL_WORKORDERS WO,
7475: AHL_VISIT_TASKS_B VT
7476: WHERE WO.status_code <> G_JOB_STATUS_DELETED
7477: AND WO.visit_task_id = VT.visit_task_id
7478: AND VT.task_type_code IN ( 'SUMMARY', 'UNASSOCIATED' )
7479: AND VT.unit_effectivity_id = c_unit_effectivity_id;

Line 7971: AHL_VISIT_TASKS_B VT

7967: CURSOR get_ue_mwo( c_unit_effectivity_id NUMBER ) IS
7968: SELECT WO.workorder_name workorder_name,
7969: WO.wip_entity_id wip_entity_id
7970: FROM AHL_WORKORDERS WO,
7971: AHL_VISIT_TASKS_B VT
7972: WHERE WO.visit_task_id = VT.visit_task_id
7973: AND WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,
7974: G_JOB_STATUS_COMPLETE_NC,
7975: G_JOB_STATUS_CANCELLED,

Line 8390: AHL_VISIT_TASKS_B VT

8386: WO.wip_entity_id wip_entity_id,
8387: WO.workorder_name workorder_name,
8388: WO.master_workorder_flag master_workorder_flag
8389: FROM AHL_WORKORDERS WO,
8390: AHL_VISIT_TASKS_B VT
8391: WHERE WO.status_code <> G_JOB_STATUS_DELETED
8392: AND WO.visit_task_id = VT.visit_task_id
8393: AND VT.task_type_code IN ( 'SUMMARY', 'UNASSOCIATED' )
8394: AND VT.unit_effectivity_id = c_unit_effectivity_id;

Line 8401: AHL_VISIT_TASKS_B VT

8397: -- To get the UE Workorder
8398: CURSOR get_ue_wo( c_unit_effectivity_id NUMBER ) IS
8399: SELECT WO.wip_entity_id wip_entity_id
8400: FROM AHL_WORKORDERS WO,
8401: AHL_VISIT_TASKS_B VT
8402: WHERE WO.status_code <> G_JOB_STATUS_DELETED
8403: AND WO.visit_task_id = VT.visit_task_id
8404: AND VT.task_type_code NOT IN ('SUMMARY')
8405: AND VT.unit_effectivity_id = c_unit_effectivity_id;

Line 8467: AHL_VISIT_TASKS_B VT

8463: CURSOR get_visit_mrs( c_visit_id NUMBER ) IS
8464: SELECT UE.unit_effectivity_id unit_effectivity_id,
8465: UE.object_version_number object_version_number
8466: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8467: AHL_VISIT_TASKS_B VT
8468: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8469: AND UE.manually_planned_flag = 'Y'
8470: -- Check added by balaji by balaji for bug # 4095002
8471: -- As per the update in the bug, for Manually planned UEs of type SR

Line 8497: AHL_VISIT_TASKS_B VT,

8493: CURSOR get_ue_details_for_wo( c_workorder_id NUMBER ) IS
8494: SELECT UE.unit_effectivity_id unit_effectivity_id,
8495: UE.object_version_number object_version_number
8496: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8497: AHL_VISIT_TASKS_B VT,
8498: AHL_WORKORDERS WO
8499: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8500: AND UE.manually_planned_flag = 'Y'
8501: -- Check added by balaji by balaji for bug # 4095002

Line 10812: AHL_VISIT_TASKS_B VTS,

10808: WDJ.PRIORITY PRIORITY
10809: FROM
10810: AHL_WORKORDERS WO,
10811: AHL_VISITS_B VST,
10812: AHL_VISIT_TASKS_B VTS,
10813: WIP_DISCRETE_JOBS WDJ,
10814: CSI_ITEM_INSTANCES CSI
10815: WHERE
10816: WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID

Line 11979: AHL_VISIT_TASKS_B VTS

11975: CURSOR get_contract_id ( c_contract_number NUMBER, c_visit_task_id NUMBER) IS
11976: SELECT WARRANTY_CONTRACT_ID
11977: FROM AHL_WARRANTY_CONTRACTS_B AWCB,
11978: AHL_VISITS_B VST,
11979: AHL_VISIT_TASKS_B VTS
11980: WHERE VTS.VISIT_TASK_ID = c_visit_task_id
11981: AND VTS.VISIT_ID = VST.VISIT_ID
11982: AND NVL(VTS.INSTANCE_ID,VST.ITEM_INSTANCE_ID) = AWCB.ITEM_INSTANCE_ID
11983: AND CONTRACT_STATUS_CODE = 'ACTIVE'

Line 11994: FROM AHL_VISIT_TASKS_B

11990: where VISIT_TASK_ID = c_visit_task_id;
11991:
11992: CURSOR get_sr_incident_id(c_visit_task_id NUMBER) IS
11993: SELECT service_request_id
11994: FROM AHL_VISIT_TASKS_B
11995: WHERE TASK_TYPE_CODE = 'PLANNED'
11996: AND MR_ROUTE_ID IS NULL;
11997:
11998: BEGIN

Line 12160: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts

12156: CURSOR Get_Wo_Cur_Values(c_workorder_id NUMBER) IS
12157: --sukhwsin::Bug 12915297. Removed Hold Reason.
12158: --select wo.status_code, wo.hold_reason_code, vst.organization_id
12159: select wo.status_code, vst.organization_id
12160: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts
12161: where
12162: wo.visit_task_id = vts.visit_task_id
12163: and vts.visit_id = vst.visit_id
12164: and wo.workorder_id = c_workorder_id;

Line 12168: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts,ahl_workorder_operations oper

12164: and wo.workorder_id = c_workorder_id;
12165: --Cursor to get Operation organization_id, seq_num and status_code
12166: CURSOR Get_Op_Details(c_workorder_op_id NUMBER) IS
12167: select vst.organization_id, oper.operation_sequence_num, oper.status_code, wo.workorder_id
12168: from ahl_workorders wo, ahl_visits_b vst, ahl_visit_tasks_b vts,ahl_workorder_operations oper
12169: where
12170: wo.visit_task_id = vts.visit_task_id
12171: and vts.visit_id = vst.visit_id
12172: and oper.workorder_id = wo.workorder_id

Line 12354: FROM ahl_visit_tasks_b vtsk, ahl_unit_effectivities_b ue

12350: vtsk.unit_effectivity_id,
12351: DECODE(ue.defer_from_ue_id, NULL,
12352: decode(vtsk.service_request_id, NULL, decode(vtsk.task_type_code,'PLANNED', 'ROUTINE', 'ROUTINE_UNKNOWN'), 'NONROUTINE'),
12353: decode(vtsk.service_request_id, NULL, 'DEFER_ROUTINE','DEFER_NONROUTINE')) maintenance_type_code
12354: FROM ahl_visit_tasks_b vtsk, ahl_unit_effectivities_b ue
12355: WHERE vtsk.unit_effectivity_id = ue.unit_effectivity_id(+)
12356: AND vtsk.visit_task_id = c_visit_task_id;
12357:
12358: CURSOR get_uc_from_visit(c_visit_id NUMBER) IS