[Home] [Help]
230: WDJ.COMPLETION_SUBINVENTORY,
231: WDJ.COMPLETION_LOCATOR_ID,
232: WO.visit_id,
233: WO.visit_task_id
234: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
235: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
236: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
237: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
238: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)
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
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; */
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
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)
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'
5570: WO.status_code wo_status_code,
5571: WO.plan_id wo_plan_id,
5572: WO.collection_id wo_collection_id,
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
5610: WO.plan_id wo_plan_id,
5611: WO.collection_id wo_collection_id,
5612: WO.master_workorder_flag,
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
5694: CWO.status_code status_code,
5695: CWO.master_workorder_flag master_workorder_flag,
5696: CWO.plan_id plan_id,
5697: CWO.collection_id collection_id
5698: FROM WIP_DISCRETE_JOBS WIP,
5699: AHL_WORKORDERS CWO,
5700: WIP_SCHED_RELATIONSHIPS REL
5701: WHERE WIP.wip_entity_id = CWO.wip_entity_id
5702: AND CWO.wip_entity_id = REL.child_object_id
5740: G_JOB_STATUS_DELETED
5741: )
5742: AND WIP.WIP_ENTITY_ID IN (
5743: SELECT CWO.wip_entity_id
5744: FROM WIP_DISCRETE_JOBS WIP,
5745: AHL_WORKORDERS CWO,
5746: WIP_SCHED_RELATIONSHIPS REL
5747: WHERE WIP.wip_entity_id = CWO.wip_entity_id
5748: AND CWO.wip_entity_id = REL.child_object_id
7746: WO.actual_end_date actual_end_date,
7747: WO.status_code wo_status_code,
7748: WO.plan_id wo_plan_id,
7749: WO.collection_id wo_collection_id
7750: FROM WIP_DISCRETE_JOBS WIP,
7751: AHL_WORKORDERS WO,
7752: AHL_VISITS_B VST
7753: WHERE WIP.wip_entity_id = WO.wip_entity_id
7754: AND WO.visit_task_id IS NULL
7906: WO.status_code status_code,
7907: WO.master_workorder_flag master_workorder_flag,
7908: WO.plan_id plan_id,
7909: WO.collection_id collection_id
7910: FROM WIP_DISCRETE_JOBS WIP,
7911: AHL_WORKORDERS WO
7912: WHERE WIP.wip_entity_id = WO.wip_entity_id
7913: AND WO.status_code <> G_JOB_STATUS_DELETED
7914: AND WO.visit_task_id IS NOT NULL
9606:
9607: -- To get the Child Workorder Details for a UE
9608: CURSOR get_ue_workorders( c_wip_entity_id NUMBER ) IS
9609: SELECT CWO.workorder_id workorder_id
9610: FROM WIP_DISCRETE_JOBS WIP,
9611: AHL_WORKORDERS CWO,
9612: WIP_SCHED_RELATIONSHIPS REL
9613: WHERE WIP.wip_entity_id = CWO.wip_entity_id
9614: AND CWO.wip_entity_id = REL.child_object_id
9632: AND WOP.workorder_id = CWO.workorder_id
9633: AND WIP.wip_entity_id = CWO.wip_entity_id
9634: AND WIP.WIP_ENTITY_ID IN (
9635: SELECT CWO.wip_entity_id
9636: FROM WIP_DISCRETE_JOBS WIP,
9637: AHL_WORKORDERS CWO,
9638: WIP_SCHED_RELATIONSHIPS REL
9639: WHERE WIP.wip_entity_id = CWO.wip_entity_id
9640: AND CWO.wip_entity_id = REL.child_object_id
10231: -- cursor to check if all workorders in a visit are cancelled.
10232: CURSOR chk_cmplt_wo_exists(c_wip_entity_id NUMBER )
10233: IS
10234: SELECT 'x'
10235: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ
10236: WHERE awo.wip_entity_id = wdj.wip_entity_id
10237: AND wdj.date_completed IS NOT NULL
10238: --AND master_workorder_flag = 'N'
10239: --AND status_code NOT IN ('7', '22', '12')
10439: AWO.attribute14,
10440: AWO.attribute15
10441: FROM
10442: AHL_WORKORDERS AWO,
10443: WIP_DISCRETE_JOBS WIPJ,
10444: WIP_ENTITIES WIPE
10445: WHERE
10446: AWO.status_code in (4,5,7)
10447: AND AWO.wip_entity_id = WIPJ.wip_entity_id