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

Line 253: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,

249: NVL(VTS.instance_id, VST.item_instance_id),
250: CSI.lot_number,
251: CSI.serial_number,
252: CSI.quantity
253: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
254: AHL_UNIT_EFFECTIVITIES_B UE
255: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
256: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
257: AND VST.visit_id = VTS.visit_id

Line 266: (select instance_id from ahl_visit_tasks_b where visit_id = c_visit_id and instance_id IS NOT NULL AND rownum = 1) VTSINST

262: CSI.lot_number,
263: CSI.serial_number,
264: CSI.quantity
265: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,
266: (select instance_id from ahl_visit_tasks_b where visit_id = c_visit_id and instance_id IS NOT NULL AND rownum = 1) VTSINST
267: WHERE nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id )= CSI.INSTANCE_ID
268: AND VST.visit_id = c_visit_id;
269:
270: -- Cursor for getting auto_signoff_flag from mr header. Added for bug # 4078536

Line 276: AHL_VISIT_TASKS_B VT,

272: SELECT
273: MR.auto_signoff_flag
274: FROM
275: AHL_MR_HEADERS_APP_V MR,
276: AHL_VISIT_TASKS_B VT,
277: AHL_WORKORDERS WO
278: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
279: WO.VISIT_TASK_ID = VT.visit_task_id AND
280: WO.workorder_id = c_workorder_id;*/

Line 288: AHL_VISIT_TASKS_B VT

284: SELECT
285: MR.auto_signoff_flag
286: FROM
287: AHL_MR_HEADERS_APP_V MR,
288: AHL_VISIT_TASKS_B VT
289: --AHL_WORKORDERS WO
290: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
291: VT.visit_task_id = c_visit_task_id;
292:

Line 4408: AHL_VISIT_TASKS_B VT

4404: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4405: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4406: WO.status_code ) status_code
4407: FROM AHL_WORKORDERS WO,
4408: AHL_VISIT_TASKS_B VT
4409: WHERE WO.visit_task_id = VT.visit_task_id
4410: AND WO.status_code <> G_JOB_STATUS_DELETED
4411: AND WO.master_workorder_flag = 'N'
4412: AND VT.unit_effectivity_id = c_unit_effectivity_id;

Line 4429: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ

4425: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4426: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4427: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4428: CWO.status_code ) status_code
4429: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4430: where CWO.visit_task_id = vst.visit_task_id
4431: AND vst.unit_effectivity_id = c_unit_effectivity_id
4432: AND CWO.master_workorder_flag = 'N'
4433: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4439: AHL_VISIT_TASKS_B VT,

4435: START WITH REL.parent_object_id IN
4436: (
4437: SELECT PWO.wip_entity_id
4438: FROM AHL_WORKORDERS PWO,
4439: AHL_VISIT_TASKS_B VT,
4440: AHL_VISITS_B VS
4441: WHERE PWO.master_workorder_flag = 'Y'
4442: AND PWO.visit_task_id = VT.visit_task_id
4443: AND VS.VISIT_ID = VT.VISIT_ID

Line 4472: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ

4468: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4469: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4470: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4471: CWO.status_code ) status_code
4472: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4473: where CWO.visit_task_id = vst.visit_task_id
4474: AND vst.unit_effectivity_id = c_unit_effectivity_id
4475: AND vst.task_type_code = 'UNASSOCIATED'
4476: AND WIPJ.wip_entity_id = CWO.wip_entity_id; */

Line 4494: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ

4490: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4491: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4492: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4493: CWO.status_code ) status_code
4494: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4495: where CWO.visit_task_id = vst.visit_task_id
4496: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4497: AND CWO.master_workorder_flag = 'N'
4498: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4504: AHL_VISIT_TASKS_B VT,

4500: START WITH REL.parent_object_id IN
4501: (
4502: SELECT PWO.wip_entity_id
4503: FROM AHL_WORKORDERS PWO,
4504: AHL_VISIT_TASKS_B VT,
4505: AHL_VISITS_B VS
4506: WHERE PWO.master_workorder_flag = 'Y'
4507: AND PWO.visit_task_id = VT.visit_task_id
4508: AND VS.VISIT_ID = VT.VISIT_ID

Line 4525: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4521: --to check released/unpleased/qa-pending
4522: CURSOR get_mr_status_csr(c_unit_effectivity_id NUMBER,p_status_code VARCHAR2) IS
4523: SELECT
4524: CWO.status_code
4525: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4526: where CWO.visit_task_id = vst.visit_task_id
4527: AND CWO.master_workorder_flag = 'N'
4528: AND CWO.status_code IN (p_status_code)
4529: AND vst.unit_effectivity_id IN (select related_ue_id

Line 4543: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4539:
4540: CURSOR is_mr_on_hold_csr(c_unit_effectivity_id NUMBER) IS
4541: SELECT
4542: CWO.status_code
4543: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4544: where CWO.visit_task_id = vst.visit_task_id
4545: AND CWO.master_workorder_flag = 'N'
4546: AND CWO.status_code IN (G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4547: G_JOB_STATUS_DEFERRAL_PENDING)

Line 4562: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj

4558:
4559: CURSOR is_mr_complete_csr(c_unit_effectivity_id NUMBER) IS
4560: SELECT
4561: CWO.status_code
4562: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4563: where CWO.visit_task_id = vst.visit_task_id
4564: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4565: AND CWO.master_workorder_flag = 'N'
4566: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE)

Line 4582: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj

4578:
4579: CURSOR is_mr_cancelled_csr(c_unit_effectivity_id NUMBER) IS
4580: SELECT
4581: CWO.status_code
4582: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4583: where CWO.visit_task_id = vst.visit_task_id
4584: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4585: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4586: AND CWO.master_workorder_flag = 'N'

Line 4921: ahl_visit_tasks_b VTSK,

4917: SELECT
4918: UE.title
4919: FROM
4920: ahl_workorders WO,
4921: ahl_visit_tasks_b VTSK,
4922: ahl_unit_effectivities_v UE
4923: WHERE
4924: WO.workorder_id = p_workorder_id
4925: AND VTSK.visit_task_id = WO.visit_task_id

Line 5577: AHL_VISIT_TASKS_B VT,

5573: WO.master_workorder_flag
5574: FROM WIP_DISCRETE_JOBS WIP,
5575: AHL_WORKORDERS WO,
5576: AHL_WORKORDERS VWO,
5577: AHL_VISIT_TASKS_B VT,
5578: AHL_UE_DEFERRAL_DETAILS_V UE
5579: WHERE WIP.wip_entity_id = WO.wip_entity_id
5580: AND WO.visit_task_id = VT.visit_task_id
5581: AND VWO.visit_task_id IS NULL

Line 5617: AHL_VISIT_TASKS_B VT,

5613: WIP.ORGANIZATION_ID org_id
5614: FROM WIP_DISCRETE_JOBS WIP,
5615: AHL_WORKORDERS WO,
5616: AHL_WORKORDERS VWO,
5617: AHL_VISIT_TASKS_B VT,
5618: AHL_UNIT_EFFECTIVITIES_APP_V UE
5619: WHERE WIP.wip_entity_id = WO.wip_entity_id
5620: AND WO.visit_task_id = VT.visit_task_id
5621: AND VWO.visit_task_id IS NULL

Line 7773: AHL_VISIT_TASKS_B VT

7769: UE.qa_inspection_type_code qa_inspection_type_code,
7770: UE.qa_plan_id qa_plan_id,
7771: UE.qa_collection_id qa_collection_id
7772: FROM AHL_UE_DEFERRAL_DETAILS_V UE,
7773: AHL_VISIT_TASKS_B VT
7774: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
7775: AND ((VT.originating_task_id IS NULL
7776: AND VT.task_type_code = 'SUMMARY')
7777: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ))

Line 7790: AHL_VISIT_TASKS_B VT,

7786: UE.qa_inspection_type_code qa_inspection_type_code,
7787: UE.qa_plan_id qa_plan_id,
7788: UE.qa_collection_id qa_collection_id
7789: FROM AHL_UE_DEFERRAL_DETAILS_V UE,
7790: AHL_VISIT_TASKS_B VT,
7791: ahl_workorders awo
7792: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
7793: AND ( (VT.task_type_code = 'SUMMARY')
7794: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )

Line 7820: AHL_VISIT_TASKS_B VT,

7816: DECODE( UE.Mr_header_id, null,null,(select QA_INSPECTION_TYPE from AHL_MR_HEADERS_B MR where MR.mr_header_id = UE.mr_header_id )) qa_inspection_type_code,
7817: -1 qa_plan_id,
7818: UE.qa_collection_id qa_collection_id
7819: FROM AHL_UNIT_EFFECTIVITIES_B UE,
7820: AHL_VISIT_TASKS_B VT,
7821: ahl_workorders awo
7822: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
7823: AND ( (VT.task_type_code = 'SUMMARY')
7824: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )

Line 9577: AHL_VISIT_TASKS_B VT,

9573: --UE.qa_collection_id ue_qa_collection_id,
9574: WO.workorder_id workorder_id,
9575: WO.wip_entity_id wip_entity_id
9576: FROM AHL_WORKORDERS WO,
9577: AHL_VISIT_TASKS_B VT,
9578: --AHL_UE_DEFERRAL_DETAILS_V UE
9579: AHL_UNIT_EFFECTIVITIES_B UE
9580: WHERE WO.visit_task_id = VT.visit_task_id
9581: AND VT.task_type_code IN ( 'SUMMARY' , 'UNASSOCIATED' )

Line 10214: AHL_VISIT_TASKS_B VTS

10210: SELECT WO.workorder_id,
10211: WO.object_version_number, VTS.task_type_code,
10212: WO.wip_entity_id
10213: FROM AHL_WORKORDERS WO,
10214: AHL_VISIT_TASKS_B VTS
10215: WHERE WO.visit_task_id = VTS.visit_task_id
10216: AND VTS.unit_effectivity_id = c_ue_id
10217: --AND WO.status_code NOT IN ('7', '22', '4', '12', '5')
10218: AND VTS.task_type_code IN ('SUMMARY', 'UNASSOCIATED');

Line 10920: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST

10916: AND cs.incident_id = p_cs_incident_id;
10917:
10918: CURSOR visit_task_csr(p_unit_effectivity_id IN NUMBER)IS
10919: SELECT VST.ORGANIZATION_ID,VT.visit_task_id
10920: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST
10921: WHERE VT.TASK_TYPE_CODE IN ( 'SUMMARY' , 'UNASSOCIATED' )
10922: AND VST.VISIT_ID = VT.VISIT_ID
10923: AND VT.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;
10924: