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 279: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,

275: NVL(VTS.instance_id, VST.item_instance_id),
276: CSI.lot_number,
277: CSI.serial_number,
278: CSI.quantity
279: FROM AHL_VISITS_B VST, AHL_VISIT_TASKS_B VTS, CSI_ITEM_INSTANCES CSI,
280: AHL_UNIT_EFFECTIVITIES_B UE
281: WHERE VTS.unit_effectivity_id = UE.unit_effectivity_id
282: AND NVL(VTS.instance_id, VST.item_instance_id) = CSI.instance_id
283: AND VST.visit_id = VTS.visit_id

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

288: CSI.lot_number,
289: CSI.serial_number,
290: CSI.quantity
291: FROM AHL_VISITS_B VST,CSI_ITEM_INSTANCES CSI,
292: (select instance_id from ahl_visit_tasks_b where visit_id = c_visit_id and instance_id IS NOT NULL AND rownum = 1) VTSINST
293: WHERE nvl (VST.ITEM_INSTANCE_ID, VTSINST.instance_id )= CSI.INSTANCE_ID
294: AND VST.visit_id = c_visit_id;
295:
296: -- Cursor for getting auto_signoff_flag from mr header. Added for bug # 4078536

Line 302: AHL_VISIT_TASKS_B VT,

298: SELECT
299: MR.auto_signoff_flag
300: FROM
301: AHL_MR_HEADERS_APP_V MR,
302: AHL_VISIT_TASKS_B VT,
303: AHL_WORKORDERS WO
304: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
305: WO.VISIT_TASK_ID = VT.visit_task_id AND
306: WO.workorder_id = c_workorder_id;*/

Line 314: AHL_VISIT_TASKS_B VT

310: SELECT
311: MR.auto_signoff_flag
312: FROM
313: AHL_MR_HEADERS_APP_V MR,
314: AHL_VISIT_TASKS_B VT
315: --AHL_WORKORDERS WO
316: WHERE MR.MR_HEADER_ID = VT.MR_ID AND
317: VT.visit_task_id = c_visit_task_id;
318:

Line 4524: AHL_VISIT_TASKS_B VT

4520: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4521: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4522: WO.status_code ) status_code
4523: FROM AHL_WORKORDERS WO,
4524: AHL_VISIT_TASKS_B VT
4525: WHERE WO.visit_task_id = VT.visit_task_id
4526: AND WO.status_code <> G_JOB_STATUS_DELETED
4527: AND WO.master_workorder_flag = 'N'
4528: AND VT.unit_effectivity_id = c_unit_effectivity_id;

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

4541: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4542: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4543: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4544: CWO.status_code ) status_code
4545: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4546: where CWO.visit_task_id = vst.visit_task_id
4547: AND vst.unit_effectivity_id = c_unit_effectivity_id
4548: AND CWO.master_workorder_flag = 'N'
4549: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4555: AHL_VISIT_TASKS_B VT,

4551: START WITH REL.parent_object_id IN
4552: (
4553: SELECT PWO.wip_entity_id
4554: FROM AHL_WORKORDERS PWO,
4555: AHL_VISIT_TASKS_B VT,
4556: AHL_VISITS_B VS
4557: WHERE PWO.master_workorder_flag = 'Y'
4558: AND PWO.visit_task_id = VT.visit_task_id
4559: AND VS.VISIT_ID = VT.VISIT_ID

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

4584: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4585: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4586: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4587: CWO.status_code ) status_code
4588: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4589: where CWO.visit_task_id = vst.visit_task_id
4590: AND vst.unit_effectivity_id = c_unit_effectivity_id
4591: AND vst.task_type_code = 'UNASSOCIATED'
4592: AND WIPJ.wip_entity_id = CWO.wip_entity_id; */

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

4606: G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE,
4607: G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4608: G_JOB_STATUS_DEFERRAL_PENDING,G_JOB_STATUS_ON_HOLD,
4609: CWO.status_code ) status_code
4610: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs WIPJ
4611: where CWO.visit_task_id = vst.visit_task_id
4612: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4613: AND CWO.master_workorder_flag = 'N'
4614: AND CWO.wip_entity_id in (SELECT REL.child_object_id

Line 4620: AHL_VISIT_TASKS_B VT,

4616: START WITH REL.parent_object_id IN
4617: (
4618: SELECT PWO.wip_entity_id
4619: FROM AHL_WORKORDERS PWO,
4620: AHL_VISIT_TASKS_B VT,
4621: AHL_VISITS_B VS
4622: WHERE PWO.master_workorder_flag = 'Y'
4623: AND PWO.visit_task_id = VT.visit_task_id
4624: AND VS.VISIT_ID = VT.VISIT_ID

Line 4641: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4637: --to check released/unpleased/qa-pending
4638: CURSOR get_mr_status_csr(c_unit_effectivity_id NUMBER,p_status_code VARCHAR2) IS
4639: SELECT
4640: CWO.status_code
4641: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4642: where CWO.visit_task_id = vst.visit_task_id
4643: AND CWO.master_workorder_flag = 'N'
4644: AND CWO.status_code IN (p_status_code)
4645: AND vst.unit_effectivity_id IN (select related_ue_id

Line 4659: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst

4655:
4656: CURSOR is_mr_on_hold_csr(c_unit_effectivity_id NUMBER) IS
4657: SELECT
4658: CWO.status_code
4659: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst
4660: where CWO.visit_task_id = vst.visit_task_id
4661: AND CWO.master_workorder_flag = 'N'
4662: AND CWO.status_code IN (G_JOB_STATUS_PARTS_HOLD, G_JOB_STATUS_ON_HOLD,
4663: G_JOB_STATUS_DEFERRAL_PENDING)

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

4674:
4675: CURSOR is_mr_complete_csr(c_unit_effectivity_id NUMBER) IS
4676: SELECT
4677: CWO.status_code
4678: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4679: where CWO.visit_task_id = vst.visit_task_id
4680: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4681: AND CWO.master_workorder_flag = 'N'
4682: AND CWO.status_code IN (G_JOB_STATUS_CLOSED, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_COMPLETE)

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

4694:
4695: CURSOR is_mr_cancelled_csr(c_unit_effectivity_id NUMBER) IS
4696: SELECT
4697: CWO.status_code
4698: FROM AHL_WORKORDERS CWO, ahl_visit_tasks_b vst, wip_discrete_jobs wipj
4699: where CWO.visit_task_id = vst.visit_task_id
4700: AND WIPJ.wip_entity_id = CWO.wip_entity_id
4701: --AND vst.unit_effectivity_id = c_unit_effectivity_id
4702: AND CWO.master_workorder_flag = 'N'

Line 5095: ahl_visit_tasks_b VTSK,

5091: SELECT
5092: UE.title
5093: FROM
5094: ahl_workorders WO,
5095: ahl_visit_tasks_b VTSK,
5096: ahl_unit_effectivities_v UE
5097: WHERE
5098: WO.workorder_id = p_workorder_id
5099: AND VTSK.visit_task_id = WO.visit_task_id

Line 5859: AHL_VISIT_TASKS_B VT,

5855: WO.master_workorder_flag
5856: FROM WIP_DISCRETE_JOBS WIP,
5857: AHL_WORKORDERS WO,
5858: AHL_WORKORDERS VWO,
5859: AHL_VISIT_TASKS_B VT,
5860: AHL_UE_DEFERRAL_DETAILS_V UE
5861: WHERE WIP.wip_entity_id = WO.wip_entity_id
5862: AND WO.visit_task_id = VT.visit_task_id
5863: AND VWO.visit_task_id IS NULL

Line 5899: AHL_VISIT_TASKS_B VT,

5895: WIP.ORGANIZATION_ID org_id
5896: FROM WIP_DISCRETE_JOBS WIP,
5897: AHL_WORKORDERS WO,
5898: AHL_WORKORDERS VWO,
5899: AHL_VISIT_TASKS_B VT,
5900: AHL_UNIT_EFFECTIVITIES_APP_V UE
5901: WHERE WIP.wip_entity_id = WO.wip_entity_id
5902: AND WO.visit_task_id = VT.visit_task_id
5903: AND VWO.visit_task_id IS NULL

Line 8179: AHL_VISIT_TASKS_B VT

8175: UE.qa_inspection_type_code qa_inspection_type_code,
8176: UE.qa_plan_id qa_plan_id,
8177: UE.qa_collection_id qa_collection_id
8178: FROM AHL_UE_DEFERRAL_DETAILS_V UE,
8179: AHL_VISIT_TASKS_B VT
8180: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8181: AND ((VT.originating_task_id IS NULL
8182: AND VT.task_type_code = 'SUMMARY')
8183: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ))

Line 8196: AHL_VISIT_TASKS_B VT,

8192: UE.qa_inspection_type_code qa_inspection_type_code,
8193: UE.qa_plan_id qa_plan_id,
8194: UE.qa_collection_id qa_collection_id
8195: FROM AHL_UE_DEFERRAL_DETAILS_V UE,
8196: AHL_VISIT_TASKS_B VT,
8197: ahl_workorders awo
8198: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8199: AND ( (VT.task_type_code = 'SUMMARY')
8200: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )

Line 8226: AHL_VISIT_TASKS_B VT,

8222: 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,
8223: -1 qa_plan_id,
8224: UE.qa_collection_id qa_collection_id
8225: FROM AHL_UNIT_EFFECTIVITIES_B UE,
8226: AHL_VISIT_TASKS_B VT,
8227: ahl_workorders awo
8228: WHERE UE.unit_effectivity_id = VT.unit_effectivity_id
8229: AND ( (VT.task_type_code = 'SUMMARY')
8230: OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )

Line 8319: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK

8315: WO.plan_id plan_id,
8316: WO.collection_id collection_id,
8317: TSK.task_type_code
8318: FROM WIP_DISCRETE_JOBS WIP,
8319: AHL_WORKORDERS WO, AHL_VISIT_TASKS_B TSK
8320: WHERE WIP.wip_entity_id = WO.wip_entity_id
8321: AND WO.visit_task_id = TSK.visit_task_id
8322: AND WO.status_code <> G_JOB_STATUS_DELETED
8323: AND WO.visit_task_id IS NOT NULL

Line 8328: -- MANESING, 14-May-2012, added table AHL_VISIT_TASKS_B in query to get task_type_code

8324: AND WO.visit_id = c_visit_id
8325: ORDER BY WO.master_workorder_flag;
8326:
8327: -- To get all the Child Operation Details for a Visit
8328: -- MANESING, 14-May-2012, added table AHL_VISIT_TASKS_B in query to get task_type_code
8329: CURSOR get_visit_operations( c_visit_id NUMBER ) IS
8330: SELECT WOP.workorder_operation_id workorder_operation_id,
8331: WOP.object_version_number object_version_number,
8332: WO.workorder_name workorder_name,

Line 8347: AHL_VISIT_TASKS_B TSK

8343:
8344: FROM AHL_WORKORDER_OPERATIONS WOP,
8345: WIP_OPERATIONS WIP,
8346: AHL_WORKORDERS WO,
8347: AHL_VISIT_TASKS_B TSK
8348:
8349: WHERE WOP.operation_sequence_num = WIP.operation_seq_num
8350: AND WOP.workorder_id = WO.workorder_id
8351: AND WIP.wip_entity_id = WO.wip_entity_id

Line 8439: AHL_VISIT_TASKS_B TSK

8435: -- Cursor to find default Stage work order id for the given visit
8436: CURSOR get_default_stage_wo_csr (c_visit_id NUMBER) IS
8437: SELECT WO.workorder_id
8438: FROM AHL_WORKORDERS WO,
8439: AHL_VISIT_TASKS_B TSK
8440: WHERE WO.visit_id = c_visit_id
8441: AND TSK.visit_task_id = WO.visit_task_id
8442: AND TSK.task_type_code = 'STAGE'
8443: AND TSK.stage_id IS NULL;

Line 10362: AHL_VISIT_TASKS_B VT,

10358: --UE.qa_collection_id ue_qa_collection_id,
10359: WO.workorder_id workorder_id,
10360: WO.wip_entity_id wip_entity_id
10361: FROM AHL_WORKORDERS WO,
10362: AHL_VISIT_TASKS_B VT,
10363: --AHL_UE_DEFERRAL_DETAILS_V UE
10364: AHL_UNIT_EFFECTIVITIES_B UE
10365: WHERE WO.visit_task_id = VT.visit_task_id
10366: AND VT.task_type_code IN ( 'SUMMARY' , 'UNASSOCIATED' )

Line 11041: AHL_VISIT_TASKS_B VTS

11037: SELECT WO.workorder_id,
11038: WO.object_version_number, VTS.task_type_code,
11039: WO.wip_entity_id
11040: FROM AHL_WORKORDERS WO,
11041: AHL_VISIT_TASKS_B VTS
11042: WHERE WO.visit_task_id = VTS.visit_task_id
11043: AND VTS.unit_effectivity_id = c_ue_id
11044: --AND WO.status_code NOT IN ('7', '22', '4', '12', '5')
11045: AND VTS.task_type_code IN ('SUMMARY', 'UNASSOCIATED');

Line 11775: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST

11771: AND cs.incident_id = p_cs_incident_id;
11772:
11773: CURSOR visit_task_csr(p_unit_effectivity_id IN NUMBER)IS
11774: SELECT VST.ORGANIZATION_ID,VT.visit_task_id
11775: FROM AHL_VISIT_TASKS_B VT, AHL_VISITS_B VST
11776: WHERE VT.TASK_TYPE_CODE IN ( 'SUMMARY' , 'UNASSOCIATED' )
11777: AND VST.VISIT_ID = VT.VISIT_ID
11778: AND VT.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;
11779:

Line 12094: FROM AHL_VISIT_TASKS_B VT,

12090:
12091: --To Get the Wip_Entity_id
12092: CURSOR get_wip_entity_id( c_unit_effectivity_id NUMBER ) IS
12093: SELECT WO.wip_entity_id,WO.workorder_id
12094: FROM AHL_VISIT_TASKS_B VT,
12095: AHL_UNIT_EFFECTIVITIES_APP_V UE,
12096: AHL_WORKORDERS WO
12097: WHERE WO.visit_task_id = VT.visit_task_id
12098: AND VT.unit_effectivity_id = UE.unit_effectivity_id

Line 12107: FROM AHL_VISIT_TASKS_B VT,

12103: --To Get the Ue Details ue_id,version
12104: CURSOR get_ue_det( c_workorder_id NUMBER ) IS
12105: SELECT UE.unit_effectivity_id,
12106: UE.OBJECT_VERSION_NUMBER
12107: FROM AHL_VISIT_TASKS_B VT,
12108: AHL_UNIT_EFFECTIVITIES_APP_V UE,
12109: AHL_WORKORDERS WO
12110: WHERE WO.visit_task_id = VT.visit_task_id
12111: AND VT.unit_effectivity_id = UE.unit_effectivity_id

Line 12620: AHL_UNIT_EFFECTIVITIES_B UE, AHL_VISIT_TASKS_B VT, ahl_workorders awo

12616: CURSOR c_get_unit_name_visit( c_visit_id NUMBER ) IS
12617: SELECT
12618: distinct ahl_util_uc_pkg.get_unit_name(UE.csi_item_instance_id) unit_name
12619: FROM
12620: AHL_UNIT_EFFECTIVITIES_B UE, AHL_VISIT_TASKS_B VT, ahl_workorders awo
12621: WHERE
12622: UE.unit_effectivity_id = VT.unit_effectivity_id
12623: AND ( (VT.task_type_code = 'SUMMARY') OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
12624: AND vt.visit_task_id = awo.visit_task_id