[Home] [Help]
4417: WIPJ.scheduled_completion_date scheduled_end_date,
4418: WO.actual_start_date,
4419: WO.actual_end_date
4420: FROM AHL_WORKORDERS WO,
4421: WIP_SCHED_RELATIONSHIPS WOR,
4422: WIP_DISCRETE_JOBS wipj
4423: WHERE
4424: WIPJ.wip_entity_id = WO.wip_entity_id
4425: AND WO.wip_entity_id = WOR.parent_object_id
4444: AND WO.status_code <> G_JOB_STATUS_DELETED
4445: AND WO.wip_entity_id in
4446: (
4447: SELECT child_object_id
4448: FROM WIP_SCHED_RELATIONSHIPS
4449: WHERE parent_object_type_id = 1
4450: AND child_object_type_id = 1
4451: START WITH parent_object_id = c_wip_entity_id
4452: AND relationship_type = 1
7439: -- To get the Child Workorders
7440: -- Top Down for Release workorders
7441: CURSOR get_child_wos( c_wip_entity_id NUMBER ) IS
7442: SELECT REL.child_object_id
7443: FROM WIP_SCHED_RELATIONSHIPS REL
7444: WHERE REL.parent_object_type_id = 1
7445: AND REL.child_object_type_id = 1
7446: START WITH REL.parent_object_id = c_wip_entity_id
7447: AND REL.relationship_type = 1
7453: -- To get the Parent Workorders
7454: -- Top Down for Release workorders
7455: CURSOR get_parent_wos( c_wip_entity_id NUMBER ) IS
7456: SELECT REL.parent_object_id
7457: FROM WIP_SCHED_RELATIONSHIPS REL
7458: WHERE REL.parent_object_type_id = 1
7459: AND REL.child_object_type_id = 1
7460: START WITH REL.child_object_id = c_wip_entity_id
7461: AND REL.relationship_type = 1
7950:
7951: CURSOR get_visit_dependencies( c_visit_id NUMBER, c_wip_entity_id NUMBER ) IS
7952: SELECT WO.workorder_name workorder_name
7953: FROM AHL_WORKORDERS WO,
7954: WIP_SCHED_RELATIONSHIPS REL
7955: WHERE WO.wip_entity_id = REL.parent_object_id
7956: AND WO.visit_id <> c_visit_id
7957: AND WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,
7958: G_JOB_STATUS_COMPLETE_NC,
7988: G_JOB_STATUS_CANCELLED,
7989: G_JOB_STATUS_CLOSED,
7990: G_JOB_STATUS_DELETED )
7991: AND WO.wip_entity_id IN (SELECT REL.child_object_id
7992: FROM WIP_SCHED_RELATIONSHIPS REL
7993: WHERE REL.parent_object_type_id = 1
7994: AND REL.child_object_type_id = 1
7995: START WITH REL.parent_object_id = c_wip_entity_id
7996: AND REL.relationship_type = 1
8010: CURSOR get_wo_dependencies( c_wip_entity_id NUMBER ) IS
8011: SELECT WO.workorder_name workorder_name,
8012: WO.wip_entity_id wip_entity_id
8013: FROM AHL_WORKORDERS WO,
8014: WIP_SCHED_RELATIONSHIPS REL
8015: WHERE WO.wip_entity_id = REL.parent_object_id
8016: AND WO.status_code NOT IN ( G_JOB_STATUS_COMPLETE,
8017: G_JOB_STATUS_COMPLETE_NC,
8018: G_JOB_STATUS_CANCELLED,
8258: -- Get Child WOs which are not cancelled
8259: CURSOR get_child_wos( c_wip_entity_id NUMBER ) IS
8260: SELECT WO.workorder_id workorder_id
8261: FROM AHL_WORKORDERS WO,
8262: WIP_SCHED_RELATIONSHIPS REL
8263: WHERE WO.status_code NOT IN ( G_JOB_STATUS_CANCELLED,
8264: G_JOB_STATUS_DELETED )
8265: AND WO.wip_entity_id = REL.child_object_id
8266: AND REL.parent_object_id = c_wip_entity_id
8431: /* bug 5104519 - end */
8432: -- To get the Child Workorders of a Master Workorder
8433: CURSOR get_child_wos( c_wip_entity_id NUMBER ) IS
8434: SELECT REL.child_object_id
8435: FROM WIP_SCHED_RELATIONSHIPS REL
8436: WHERE REL.parent_object_type_id = 1
8437: AND REL.child_object_type_id = 1
8438: START WITH REL.parent_object_id = c_wip_entity_id
8439: AND REL.relationship_type = 1
8443:
8444: -- To get the Parent Workorders of a Workorder
8445: CURSOR get_parent_wos( c_wip_entity_id NUMBER ) IS
8446: SELECT REL.parent_object_id
8447: FROM WIP_SCHED_RELATIONSHIPS REL
8448: WHERE REL.parent_object_type_id = 1
8449: AND REL.child_object_type_id = 1
8450: START WITH REL.child_object_id = c_wip_entity_id
8451: AND REL.relationship_type = 1
8538: -- in the completion dependency hierarchy
8539: CURSOR get_parent_wos_count(c_wip_entity_id NUMBER)
8540: IS
8541: SELECT count(*)
8542: FROM WIP_SCHED_RELATIONSHIPS
8543: WHERE child_object_id = c_wip_entity_id
8544: AND child_object_type_id = 1
8545: AND relationship_type = 2;
8546:
8552: SELECT REL.sched_relationship_id,
8553: REL.parent_object_id,
8554: REL.child_object_id
8555: FROM --AHL_WORKORDERS WO,
8556: WIP_SCHED_RELATIONSHIPS REL
8557: WHERE --WO.wip_entity_id = REL.child_object_id
8558: REL.parent_object_type_id = 1
8559: AND REL.child_object_type_id = 1
8560: START WITH REL.parent_object_id = c_wip_entity_id
8568: IS
8569: SELECT REL.sched_relationship_id,
8570: REL.parent_object_id,
8571: REL.child_object_id
8572: FROM WIP_SCHED_RELATIONSHIPS REL
8573: WHERE REL.parent_object_type_id = 1
8574: AND REL.child_object_type_id = 1
8575: START WITH REL.child_object_id = c_wip_entity_id
8576: AND REL.relationship_type = 2
8582: CURSOR get_immediate_ue_parent(c_wip_entity_id NUMBER)
8583: IS
8584: SELECT REL.sched_relationship_id,
8585: REL.parent_object_id
8586: FROM WIP_SCHED_RELATIONSHIPS REL
8587: WHERE REL.child_object_id = c_wip_entity_id
8588: AND REL.parent_object_type_id = 1
8589: AND REL.child_object_type_id = 1
8590: AND REL.relationship_type = 2;
8596: CURSOR get_completion_dep_wo(c_wip_entity_id NUMBER)
8597: IS
8598: SELECT REL.sched_relationship_id,
8599: REL.child_object_id
8600: FROM WIP_SCHED_RELATIONSHIPS REL
8601: WHERE REL.parent_object_id = c_wip_entity_id
8602: AND REL.parent_object_type_id = 1
8603: AND REL.child_object_type_id = 1
8604: AND REL.relationship_type = 2;
8608: CURSOR get_completion_dep_wo_child(c_wip_entity_id NUMBER)
8609: IS
8610: SELECT REL.sched_relationship_id,
8611: REL.parent_object_id
8612: FROM WIP_SCHED_RELATIONSHIPS REL
8613: WHERE REL.child_object_id = c_wip_entity_id
8614: AND REL.parent_object_type_id = 1
8615: AND REL.child_object_type_id = 1
8616: AND REL.relationship_type = 2;
8626: --AND master_workorder_flag = 'N'
8627: --AND status_code NOT IN ('7', '22', '12')
8628: AND VISIT_TASK_ID IS NOT NULL
8629: AND awo.wip_entity_id IN (SELECT rel.child_object_id
8630: FROM wip_sched_relationships rel
8631: START WITH REL.parent_object_id = c_wip_entity_id
8632: CONNECT BY REL.parent_object_id = PRIOR REL.child_object_id
8633: AND REL.parent_object_type_id = PRIOR REL.child_object_type_id
8634: AND REL.relationship_type = 1);
9956: WIP.SCHEDULED_START_DATE,
9957: WIP.SCHEDULED_COMPLETION_DATE SCHEDULED_END_DATE,
9958: level
9959: FROM AHL_WORKORDERS CWO,
9960: WIP_SCHED_RELATIONSHIPS REL,
9961: WIP_DISCRETE_JOBS WIP
9962: WHERE CWO.wip_entity_id = REL.parent_object_id
9963: AND CWO.wip_entity_id = WIP.WIP_ENTITY_ID
9964: AND WIP.firm_planned_flag = '1'
9969: START WITH REL.child_object_id IN
9970: (select wos.wip_entity_id from ahl_workorders wos, WIP_DISCRETE_JOBS WIPS
9971: where wos.wip_entity_id = wips.wip_entity_id
9972: and wips.date_completed IS NOT NULL
9973: and exists (Select 'X' from WIP_DISCRETE_JOBS WIPSP,WIP_SCHED_RELATIONSHIPS RELP
9974: where RELP.child_object_id = wips.wip_entity_id
9975: and RELP.parent_object_id = WIPSP.wip_entity_id
9976: and DECODE(c_offset_direction, 1,WIPSP.scheduled_start_date+c_offset,WIPS.scheduled_completion_date + c_offset)
9977: > DECODE(c_offset_direction, 1,WIPS.scheduled_start_date ,WIPSP.scheduled_completion_date))
9995: from ahl_workorders cwo
9996: WHERE cwo.visit_id = c_visit_id
9997: and cwo.status_code NOT IN ('22', '7', '4', '5', '12')
9998: AND cwo.master_workorder_flag = 'Y') cwo,
9999: wip_sched_relationships rel,
10000: wip_discrete_jobs wip
10001: WHERE cwo.wip_entity_id = rel.parent_object_id
10002: AND cwo.wip_entity_id = wip.wip_entity_id
10003: AND wip.firm_planned_flag = '1'
10005: AND rel.child_object_type_id = 1
10006: START WITH rel.child_object_id IN (
10007: SELECT distinct wos.wip_entity_id
10008: FROM wip_discrete_jobs wips, wip_discrete_jobs wipsp,
10009: wip_sched_relationships relp, ahl_workorders wos
10010: WHERE wos.visit_id = c_visit_id
10011: AND wos.wip_entity_id = wips.wip_entity_id
10012: AND wips.date_completed IS NOT NULL
10013: AND relp.child_object_id = wips.wip_entity_id
10032: CWO.status_code status_code,
10033: WIP.SCHEDULED_START_DATE,
10034: WIP.SCHEDULED_COMPLETION_DATE
10035: FROM AHL_WORKORDERS CWO,
10036: WIP_SCHED_RELATIONSHIPS REL,
10037: WIP_DISCRETE_JOBS WIP
10038: WHERE CWO.wip_entity_id = REL.parent_object_id
10039: AND CWO.wip_entity_id = WIP.WIP_ENTITY_ID
10040: AND WIP.firm_planned_flag = '1'
10896: WO.STATUS_CODE,
10897: WDJ.SCHEDULED_START_DATE SCHEDULED_START_DATE,
10898: WDJ.scheduled_completion_date scheduled_end_date
10899: FROM AHL_WORKORDERS WO,WIP_DISCRETE_JOBS WDJ,
10900: WIP_SCHED_RELATIONSHIPS WOR
10901: WHERE WO.WIP_ENTITY_ID = WOR.PARENT_OBJECT_ID
10902: AND WDJ.wip_entity_id = WO.wip_entity_id
10903: AND WO.master_workorder_flag = 'Y'
10904: AND WO.visit_task_id IS NOT NULL
10924: AND WO.status_code <> '22'
10925: AND WO.wip_entity_id in
10926: (
10927: SELECT child_object_id
10928: FROM WIP_SCHED_RELATIONSHIPS
10929: WHERE parent_object_type_id = 1
10930: AND child_object_type_id = 1
10931: AND parent_object_id = c_wip_entity_id
10932: AND relationship_type = 1
11348: WDJ.DATE_CLOSED,
11349: --sukhwsin::VEE Changes- included workorder_id
11350: WO.workorder_id
11351: FROM AHL_WORKORDERS WO,
11352: WIP_SCHED_RELATIONSHIPS WOR,
11353: WIP_DISCRETE_JOBS WDJ
11354: WHERE WO.wip_entity_id = WOR.parent_object_id
11355: AND WDJ.wip_entity_id = WO.wip_entity_id
11356: AND WO.master_workorder_flag = 'Y'
11650: WIP.SCHEDULED_START_DATE,
11651: WIP.SCHEDULED_COMPLETION_DATE SCHEDULED_END_DATE,
11652: level
11653: FROM AHL_WORKORDERS CWO,
11654: WIP_SCHED_RELATIONSHIPS REL,
11655: WIP_DISCRETE_JOBS WIP
11656: WHERE CWO.wip_entity_id = REL.parent_object_id
11657: AND CWO.wip_entity_id = WIP.WIP_ENTITY_ID
11658: AND CWO.master_workorder_flag = 'Y'