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 WIP_SCHED_RELATIONSHIPS

Line 1572: WIP_SCHED_RELATIONSHIPS WOR

1568: IS
1569: SELECT WO.workorder_name,
1570: WO.status_code
1571: FROM AHL_WORKORDERS WO,
1572: WIP_SCHED_RELATIONSHIPS WOR
1573: WHERE WO.wip_entity_id = WOR.parent_object_id
1574: AND WO.master_workorder_flag = 'N'
1575: AND WO.status_code <> G_JOB_STATUS_DELETED
1576: AND WOR.parent_object_type_id = 1

Line 3192: WIP_SCHED_RELATIONSHIPS WOR

3188: WO.object_version_number object_version_number,
3189: WO.wip_entity_id wip_entity_id,
3190: WO.status_code status_code
3191: FROM AHL_WORKORDERS WO,
3192: WIP_SCHED_RELATIONSHIPS WOR
3193: WHERE WO.wip_entity_id = WOR.parent_object_id
3194: AND WO.master_workorder_flag = 'Y'
3195: AND WO.status_code <> G_JOB_STATUS_DELETED
3196: AND WOR.parent_object_type_id = 1

Line 3205: WIP_SCHED_RELATIONSHIPS WOR

3201: CURSOR get_child_wo_status( c_master_wip_entity_id NUMBER )
3202: IS
3203: SELECT DISTINCT WO.status_code status_code
3204: FROM AHL_WORKORDERS WO,
3205: WIP_SCHED_RELATIONSHIPS WOR
3206: WHERE WO.wip_entity_id = WOR.child_object_id
3207: AND WO.status_code <> G_JOB_STATUS_DELETED
3208: AND WOR.parent_object_type_id = 1
3209: AND WOR.relationship_type = 1

Line 4550: from WIP_SCHED_RELATIONSHIPS REL

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
4550: from WIP_SCHED_RELATIONSHIPS REL
4551: START WITH REL.parent_object_id IN
4552: (
4553: SELECT PWO.wip_entity_id
4554: FROM AHL_WORKORDERS PWO,

Line 4615: from WIP_SCHED_RELATIONSHIPS REL

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
4615: from WIP_SCHED_RELATIONSHIPS REL
4616: START WITH REL.parent_object_id IN
4617: (
4618: SELECT PWO.wip_entity_id
4619: FROM AHL_WORKORDERS PWO,

Line 5258: WIP_SCHED_RELATIONSHIPS REL

5254: CWO.actual_end_date actual_end_date,
5255: CWO.status_code status_code,
5256: CWO.master_workorder_flag master_workorder_flag
5257: FROM AHL_WORKORDERS CWO,
5258: WIP_SCHED_RELATIONSHIPS REL
5259: WHERE CWO.wip_entity_id = REL.child_object_id
5260: AND CWO.status_code <> G_JOB_STATUS_DELETED
5261: AND REL.parent_object_type_id = 1
5262: AND REL.child_object_type_id = 1

Line 5536: WIP_SCHED_RELATIONSHIPS WOR

5532: G_JOB_STATUS_DELETED, G_JOB_STATUS_COMPLETE,
5533: WO.status_code ) parent_status_code,
5534: WOR.child_object_id child_we_id
5535: FROM AHL_WORKORDERS WO,
5536: WIP_SCHED_RELATIONSHIPS WOR
5537: WHERE WO.wip_entity_id = WOR.parent_object_id
5538: AND WOR.top_level_object_id = c_wip_entity_id
5539: AND WOR.relationship_type = 2
5540: AND WOR.parent_object_type_id = 1

Line 5982: WIP_SCHED_RELATIONSHIPS REL

5978: CWO.plan_id plan_id,
5979: CWO.collection_id collection_id
5980: FROM WIP_DISCRETE_JOBS WIP,
5981: AHL_WORKORDERS CWO,
5982: WIP_SCHED_RELATIONSHIPS REL
5983: WHERE WIP.wip_entity_id = CWO.wip_entity_id
5984: AND CWO.wip_entity_id = REL.child_object_id
5985: AND CWO.status_code <> G_JOB_STATUS_DELETED
5986: AND REL.parent_object_type_id = 1

Line 6028: WIP_SCHED_RELATIONSHIPS REL

6024: AND WIP.WIP_ENTITY_ID IN (
6025: SELECT CWO.wip_entity_id
6026: FROM WIP_DISCRETE_JOBS WIP,
6027: AHL_WORKORDERS CWO,
6028: WIP_SCHED_RELATIONSHIPS REL
6029: WHERE WIP.wip_entity_id = CWO.wip_entity_id
6030: AND CWO.wip_entity_id = REL.child_object_id
6031: AND CWO.status_code <> G_JOB_STATUS_DELETED
6032: AND REL.parent_object_type_id = 1

Line 6098: WIP_SCHED_RELATIONSHIPS REL

6094: FROM BOM_RESOURCES BOM,
6095: WIP_OPERATION_RESOURCES WOR,
6096: AHL_WORKORDER_OPERATIONS WOP,
6097: AHL_WORKORDERS CWO,
6098: WIP_SCHED_RELATIONSHIPS REL
6099: WHERE BOM.resource_type IN ( 1 , 2 )
6100: AND BOM.resource_id = WOR.resource_id
6101: AND WOR.operation_seq_num = WOP.operation_sequence_num
6102: AND WOR.wip_entity_id = CWO.wip_entity_id

Line 8205: wip_sched_relationships wsch,

8201: AND vt.visit_task_id = awo.visit_task_id
8202: and awo.wip_entity_id in ( SELECT
8203: wsch.child_object_id
8204: FROM
8205: wip_sched_relationships wsch,
8206: ahl_workorders awo1
8207: WHERE
8208: wsch.parent_object_id = awo1.wip_entity_id
8209: and awo1.visit_task_id is null

Line 8235: wip_sched_relationships wsch,

8231: AND vt.visit_task_id = awo.visit_task_id
8232: and awo.wip_entity_id in ( SELECT
8233: wsch.child_object_id
8234: FROM
8235: wip_sched_relationships wsch,
8236: ahl_workorders awo1
8237: WHERE
8238: wsch.parent_object_id = awo1.wip_entity_id
8239: and awo1.visit_task_id is null

Line 10397: WIP_SCHED_RELATIONSHIPS REL

10393: CURSOR get_ue_workorders( c_wip_entity_id NUMBER ) IS
10394: SELECT CWO.workorder_id workorder_id
10395: FROM WIP_DISCRETE_JOBS WIP,
10396: AHL_WORKORDERS CWO,
10397: WIP_SCHED_RELATIONSHIPS REL
10398: WHERE WIP.wip_entity_id = CWO.wip_entity_id
10399: AND CWO.wip_entity_id = REL.child_object_id
10400: AND CWO.status_code NOT IN (G_JOB_STATUS_DELETED, G_JOB_STATUS_COMPLETE, G_JOB_STATUS_COMPLETE_NC, G_JOB_STATUS_CANCELLED, G_JOB_STATUS_CLOSED)
10401: AND REL.parent_object_type_id = 1

Line 10423: WIP_SCHED_RELATIONSHIPS REL

10419: AND WIP.WIP_ENTITY_ID IN (
10420: SELECT CWO.wip_entity_id
10421: FROM WIP_DISCRETE_JOBS WIP,
10422: AHL_WORKORDERS CWO,
10423: WIP_SCHED_RELATIONSHIPS REL
10424: WHERE WIP.wip_entity_id = CWO.wip_entity_id
10425: AND CWO.wip_entity_id = REL.child_object_id
10426: AND CWO.status_code <> G_JOB_STATUS_DELETED
10427: AND REL.parent_object_type_id = 1

Line 11069: FROM wip_sched_relationships rel

11065: --AND master_workorder_flag = 'N'
11066: --AND status_code NOT IN ('7', '22', '12')
11067: AND VISIT_TASK_ID IS NOT NULL
11068: AND awo.wip_entity_id IN (SELECT rel.child_object_id
11069: FROM wip_sched_relationships rel
11070: START WITH REL.parent_object_id = c_wip_entity_id
11071: CONNECT BY REL.parent_object_id = PRIOR REL.child_object_id
11072: AND REL.parent_object_type_id = PRIOR REL.child_object_type_id
11073: AND REL.relationship_type = 1);

Line 12080: WIP_SCHED_RELATIONSHIPS REL

12076: CWO.actual_end_date actual_end_date,
12077: CWO.status_code status_code,
12078: CWO.master_workorder_flag master_workorder_flag
12079: FROM AHL_WORKORDERS CWO,
12080: WIP_SCHED_RELATIONSHIPS REL
12081: WHERE CWO.wip_entity_id = REL.child_object_id
12082: AND CWO.status_code <> G_JOB_STATUS_DELETED
12083: AND REL.parent_object_type_id = 1
12084: AND REL.child_object_type_id = 1

Line 12627: wip_sched_relationships wsch,

12623: AND ( (VT.task_type_code = 'SUMMARY') OR (TASK_TYPE_CODE = 'UNASSOCIATED' ) )
12624: AND vt.visit_task_id = awo.visit_task_id
12625: AND awo.wip_entity_id in ( SELECT wsch.child_object_id
12626: FROM
12627: wip_sched_relationships wsch,
12628: ahl_workorders awo1
12629: WHERE
12630: wsch.parent_object_id = awo1.wip_entity_id
12631: and awo1.visit_task_id is null