[Home] [Help]
256: WDJ.COMPLETION_SUBINVENTORY,
257: WDJ.COMPLETION_LOCATOR_ID,
258: WO.visit_id,
259: WO.visit_task_id
260: FROM AHL_WORKORDERS WO, FND_LOOKUP_VALUES_VL MLU,WIP_DISCRETE_JOBS WDJ,
261: (SELECT ORGANIZATION_ID FROM INV_ORGANIZATION_INFO_V WHERE
262: NVL (operating_unit, mo_global.get_current_org_id()) = mo_global.get_current_org_id()) ORG
263: WHERE WDJ.WIP_ENTITY_ID=WO.WIP_ENTITY_ID
264: AND MLU.LOOKUP_TYPE(+)='AHL_JOB_STATUS' AND WO.STATUS_CODE=MLU.LOOKUP_CODE(+)
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
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; */
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
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)
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'
5852: WO.status_code wo_status_code,
5853: WO.plan_id wo_plan_id,
5854: WO.collection_id wo_collection_id,
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
5892: WO.plan_id wo_plan_id,
5893: WO.collection_id wo_collection_id,
5894: WO.master_workorder_flag,
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
5976: CWO.status_code status_code,
5977: CWO.master_workorder_flag master_workorder_flag,
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
6022: G_JOB_STATUS_DELETED
6023: )
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
8152: WO.actual_end_date actual_end_date,
8153: WO.status_code wo_status_code,
8154: WO.plan_id wo_plan_id,
8155: WO.collection_id wo_collection_id
8156: FROM WIP_DISCRETE_JOBS WIP,
8157: AHL_WORKORDERS WO,
8158: AHL_VISITS_B VST
8159: WHERE WIP.wip_entity_id = WO.wip_entity_id
8160: AND WO.visit_task_id IS NULL
8314: WO.master_workorder_flag master_workorder_flag,
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
10391:
10392: -- To get the Child Workorder Details for a UE
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
10417: AND WOP.workorder_id = CWO.workorder_id
10418: AND WIP.wip_entity_id = CWO.wip_entity_id
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
11058: -- cursor to check if all workorders in a visit are cancelled.
11059: CURSOR chk_cmplt_wo_exists(c_wip_entity_id NUMBER )
11060: IS
11061: SELECT 'x'
11062: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ
11063: WHERE awo.wip_entity_id = wdj.wip_entity_id
11064: AND wdj.date_completed IS NOT NULL
11065: --AND master_workorder_flag = 'N'
11066: --AND status_code NOT IN ('7', '22', '12')
11266: AWO.attribute14,
11267: AWO.attribute15
11268: FROM
11269: AHL_WORKORDERS AWO,
11270: WIP_DISCRETE_JOBS WIPJ,
11271: WIP_ENTITIES WIPE
11272: WHERE
11273: AWO.status_code in (4,5,7)
11274: AND AWO.wip_entity_id = WIPJ.wip_entity_id