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_VWP_PROJ_PROD_PVT dependencies on AHL_WORKORDERS

Line 5521: FROM AHL_WORKORDERS

5517: ) IS
5518:
5519: CURSOR get_mwo_wip_entity_id(x_visit_id IN NUMBER) IS
5520: SELECT wip_entity_id
5521: FROM AHL_WORKORDERS
5522: WHERE visit_id = x_visit_id
5523: AND VISIT_TASK_ID IS NULL
5524: AND MASTER_WORKORDER_FLAG = 'Y';
5525:

Line 5539: SELECT 1 FROM AHL_WORKORDERS

5535: WHERE PARENT.visit_task_id = CHILD.originating_task_id
5536: AND CHILD.visit_task_id = c_visit_task_id;
5537:
5538: CURSOR does_wo_exist_csr(c_visit_task_id NUMBER) IS
5539: SELECT 1 FROM AHL_WORKORDERS
5540: WHERE VISIT_TASK_ID = c_visit_task_id;
5541:
5542: CURSOR get_wip_entity_id(c_visit_task_id NUMBER) IS
5543: SELECT wip_entity_id FROM AHL_WORKORDERS

Line 5543: SELECT wip_entity_id FROM AHL_WORKORDERS

5539: SELECT 1 FROM AHL_WORKORDERS
5540: WHERE VISIT_TASK_ID = c_visit_task_id;
5541:
5542: CURSOR get_wip_entity_id(c_visit_task_id NUMBER) IS
5543: SELECT wip_entity_id FROM AHL_WORKORDERS
5544: WHERE VISIT_TASK_ID = c_visit_task_id;
5545:
5546: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Task_Relationships';
5547: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;

Line 5739: FROM AHL_WORKORDERS

5735:
5736: CURSOR get_wo(c_visit_task_id NUMBER)
5737: IS
5738: SELECT wip_entity_id
5739: FROM AHL_WORKORDERS
5740: WHERE VISIT_TASK_ID = c_visit_task_id
5741: -- SKPATHAK :: Bug 9940275 :: 18-AUG-2010 :: Removed status '7' from below condtn
5742: -- This cursor is used to check if a visit task has a corresponding WO and if not, WO relationship needs to be created
5743: -- So even if the status is 7 (cancelled), cursor must fetch the result, since relationship need not be created in this case

Line 5749: FROM AHL_WORKORDERS

5745:
5746: CURSOR get_parent_wo(c_visit_task_id NUMBER)
5747: IS
5748: SELECT wip_entity_id
5749: FROM AHL_WORKORDERS
5750: WHERE VISIT_TASK_ID = c_visit_task_id
5751: AND STATUS_CODE NOT IN ('22','7');
5752: -- yazhou 27-Jun-2006 ends
5753:

Line 5757: FROM AHL_WORKORDERS

5753:
5754: CURSOR get_mwo(c_visit_id NUMBER)
5755: IS
5756: SELECT wip_entity_id
5757: FROM AHL_WORKORDERS
5758: WHERE visit_id = c_visit_id
5759: AND VISIT_TASK_ID IS NULL
5760: AND MASTER_WORKORDER_FLAG = 'Y'
5761: AND STATUS_CODE NOT IN ('7', '22');

Line 6168: FROM AHL_WORKORDERS

6164: /* Begin Changes by Shkalyan */
6165: -- To find job for task
6166: CURSOR c_job (x_id IN NUMBER) IS
6167: SELECT workorder_id, object_version_number, status_code
6168: FROM AHL_WORKORDERS
6169: WHERE VISIT_TASK_ID = x_id
6170: AND STATUS_CODE not in ('22','7'); --(22-Deleted, 7-Cancelled)
6171:
6172: --transit check visit change

Line 6179: FROM AHL_WORKORDERS WO,

6175: CURSOR c_visit_job (x_visit_id IN NUMBER) IS
6176: SELECT wo.workorder_id, wo.object_version_number, wo.status_code,
6177: WIP.SCHEDULED_START_DATE,
6178: WIP.SCHEDULED_COMPLETION_DATE
6179: FROM AHL_WORKORDERS WO,
6180: WIP_DISCRETE_JOBS WIP
6181: WHERE wo.VISIT_ID = x_visit_id
6182: AND wo.VISIT_TASK_ID IS NULL
6183: AND wo.MASTER_WORKORDER_FLAG = 'Y'

Line 6189: FROM AHL_WORKORDERS WO

6185: AND wo.STATUS_CODE not in ('22','7'); --(22-Deleted, 7-Cancelled)
6186:
6187: CURSOR c_visit_wo_status (x_visit_id IN NUMBER) IS
6188: SELECT wo.status_code
6189: FROM AHL_WORKORDERS WO
6190: WHERE wo.VISIT_ID = x_visit_id
6191: AND wo.VISIT_TASK_ID IS NULL
6192: AND wo.MASTER_WORKORDER_FLAG = 'Y'
6193: AND wo.STATUS_CODE not in ('22','7'); --(22-Deleted, 7-Cancelled)

Line 6198: FROM AHL_WORKORDERS WO,

6194:
6195: -- Get workorder status for the coresponding job in originating visit
6196: CURSOR c_wo_status (x_orig_visit_id IN NUMBER, x_visit_task_id IN NUMBER) IS
6197: SELECT wo.status_code
6198: FROM AHL_WORKORDERS WO,
6199: AHL_VISIT_TASKS_B t
6200: WHERE wo.VISIT_ID = x_orig_visit_id
6201: AND wo.visit_task_id = t.visit_task_id
6202: AND t.visit_task_number = (Select visit_task_number

Line 6280: FROM ahl_visit_tasks_b task, ahl_vwp_stages_b stage, ahl_workorders wo

6276: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
6277: -- Get all the planning stages' tasks and duplicate tasks of the visit
6278: CURSOR get_visit_tasks_to_cancel (c_visit_id IN NUMBER) IS
6279: SELECT wo.workorder_id, stage.stage_id, task.task_type_code
6280: FROM ahl_visit_tasks_b task, ahl_vwp_stages_b stage, ahl_workorders wo
6281: WHERE task.visit_id = c_visit_id
6282: AND task.stage_id = stage.stage_id(+)
6283: -- do not select the default stage task
6284: AND ((task.task_type_code = 'STAGE' AND task.stage_id IS NOT NULL)

Line 8751: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip

8747:
8748: --cursor to fetch master work order for the visit
8749: CURSOR c_fet_master_wo (x_visit_id IN NUMBER) IS
8750: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date
8751: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
8752: WHERE v.visit_id = x_visit_id
8753: AND NVL(v.status_code,'X') = 'PARTIALLY RELEASED'
8754: AND v.visit_id = wo.visit_id
8755: AND wo.visit_task_id IS NULL

Line 9241: SELECT 1 FROM ahl_workorders wo

9237: ) IS
9238:
9239: --check if the visit master wo exists
9240: CURSOR c_fet_master_wo (x_visit_id IN NUMBER) IS
9241: SELECT 1 FROM ahl_workorders wo
9242: WHERE wo.visit_id = x_visit_id
9243: AND wo.visit_task_id IS NULL
9244: AND wo.master_workorder_flag = 'Y';
9245:

Line 9249: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip

9245:
9246: --fetch master work order for the visit
9247: CURSOR c_visit_master_wo (x_visit_id IN NUMBER) IS
9248: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
9249: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
9250: WHERE v.visit_id = x_visit_id
9251: AND v.visit_id = wo.visit_id
9252: AND wo.visit_task_id IS NULL
9253: AND wo.master_workorder_flag = 'Y'

Line 9275: SELECT 1 FROM ahl_workorders wo

9271: c_visit_tsk_dtl_rec c_visit_task_dtl%ROWTYPE;
9272:
9273: --check if the task wo exists
9274: CURSOR c_fet_task_wo (x_visit_id IN NUMBER, x_visit_task_id IN NUMBER) IS
9275: SELECT 1 FROM ahl_workorders wo
9276: WHERE wo.visit_id = x_visit_id
9277: AND wo.visit_task_id = x_visit_task_id
9278: AND wo.visit_task_id IS NOT NULL;
9279:

Line 9283: FROM ahl_visit_tasks_b v, ahl_workorders wo, wip_discrete_jobs wip

9279:
9280: --fetch work order for the task
9281: CURSOR c_task_wo (x_visit_id IN NUMBER,x_visit_task_id IN NUMBER) IS
9282: SELECT v.visit_task_id, wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
9283: FROM ahl_visit_tasks_b v, ahl_workorders wo, wip_discrete_jobs wip
9284: WHERE v.visit_id = x_visit_id
9285: AND v.visit_id = wo.visit_id
9286: AND wo.visit_task_id IS NOT NULL
9287: AND wo.visit_task_id = x_visit_task_id

Line 9320: FROM ahl_workorders wo

9316:
9317: --check if the visit master wo exists
9318: CURSOR c_fet_mas_wo_dtls (x_visit_id IN NUMBER) IS
9319: SELECT actual_start_date,actual_end_date
9320: FROM ahl_workorders wo
9321: WHERE wo.visit_id = x_visit_id
9322: AND wo.visit_task_id IS NULL
9323: AND wo.master_workorder_flag = 'Y';
9324:

Line 9357: FROM AHL_WORKORDERS AWO,

9353: AWO.WORKORDER_ID,
9354: AWO.OBJECT_VERSION_NUMBER,
9355: WDJ.SCHEDULED_START_DATE,
9356: WDJ.SCHEDULED_COMPLETION_DATE
9357: FROM AHL_WORKORDERS AWO,
9358: WIP_DISCRETE_JOBS WDJ
9359: WHERE WDJ.WIP_ENTITY_ID = AWO.WIP_ENTITY_ID
9360: AND AWO.VISIT_TASK_ID = p_sr_task_id
9361: AND AWO.MASTER_WORKORDER_FLAG = 'Y'

Line 9387: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj

9383: OR (STAGE_ID IS NOT NULL AND TASK_TYPE_CODE = 'STAGE'));
9384:
9385: CURSOR c_visit_time_matches_MWO_time(p_visit_id IN NUMBER) IS
9386: SELECT 1
9387: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj
9388: WHERE vst.visit_id = p_visit_id
9389: AND wo.visit_id = vst.visit_id
9390: AND wo.MASTER_WORKORDER_FLAG = 'Y'
9391: AND wo.visit_task_id IS NULL

Line 9430: FROM ahl_visit_tasks_b task, ahl_workorders wo

9426:
9427: -- Get the workorder id and task type for a given task
9428: CURSOR get_task_dets (c_task_id IN NUMBER) IS
9429: SELECT task.task_type_code, wo.workorder_id
9430: FROM ahl_visit_tasks_b task, ahl_workorders wo
9431: WHERE task.visit_task_id = c_task_id
9432: AND task.visit_task_id = wo.visit_task_id;
9433: task_dets_rec get_task_dets%ROWTYPE;
9434:

Line 10418: FROM AHL_WORKORDERS

10414: c_visit_rec c_visit%ROWTYPE;
10415:
10416: CURSOR get_wo(c_visit_id NUMBER, c_unit_effectivity_id NUMBER) IS
10417: SELECT workorder_id
10418: FROM AHL_WORKORDERS
10419: WHERE VISIT_TASK_ID = (select visit_task_id from ahl_visit_tasks_b
10420: where visit_id = c_visit_id
10421: and unit_effectivity_id = c_unit_effectivity_id
10422: AND NVL(status_code, 'Y') <> 'DELETED'

Line 10436: FROM ahl_workorders

10432: WHERE wip_entity_id =
10433: (
10434: SELECT
10435: wip_entity_id
10436: FROM ahl_workorders
10437: WHERE
10438: master_workorder_flag = 'Y' AND
10439: visit_task_id IS null AND
10440: status_code not in (22,7) and

Line 10928: FROM AHL_WORKORDERS

10924:
10925: CURSOR get_wo(c_visit_task_id NUMBER)
10926: IS
10927: SELECT wip_entity_id
10928: FROM AHL_WORKORDERS
10929: WHERE VISIT_TASK_ID = c_visit_task_id
10930: -- SKPATHAK :: Bug 9940275 :: 18-AUG-2010 :: Removed status '7' from below condtn
10931: -- This cursor is used to check if a visit task has a corresponding WO and if not, WO relationship needs to be created
10932: -- So even if the status is 7 (cancelled), cursor must fetch the result, since relationship need not be created in this case

Line 10938: FROM AHL_WORKORDERS

10934:
10935: CURSOR get_parent_wo(c_visit_task_id NUMBER)
10936: IS
10937: SELECT wip_entity_id
10938: FROM AHL_WORKORDERS
10939: WHERE VISIT_TASK_ID = c_visit_task_id
10940: AND STATUS_CODE NOT IN ('7', '22');
10941:
10942: CURSOR get_mwo(c_visit_id NUMBER)

Line 10945: FROM AHL_WORKORDERS

10941:
10942: CURSOR get_mwo(c_visit_id NUMBER)
10943: IS
10944: SELECT wip_entity_id
10945: FROM AHL_WORKORDERS
10946: WHERE visit_id = c_visit_id
10947: AND VISIT_TASK_ID IS NULL
10948: AND MASTER_WORKORDER_FLAG = 'Y'
10949: AND STATUS_CODE NOT IN ('7', '22');

Line 11226: FROM ahl_workorders

11222: WHERE wip_entity_id =
11223: (
11224: SELECT
11225: wip_entity_id
11226: FROM ahl_workorders
11227: WHERE
11228: master_workorder_flag = 'Y' AND
11229: visit_task_id IS null AND
11230: status_code not in (22,7) and

Line 11258: FROM AHL_WORKORDERS WO,

11254: CURSOR get_visit_mwo_details_csr (c_visit_id IN NUMBER) IS
11255: SELECT wo.workorder_id, wo.object_version_number, wo.status_code,
11256: WIP.SCHEDULED_START_DATE,
11257: WIP.SCHEDULED_COMPLETION_DATE
11258: FROM AHL_WORKORDERS WO,
11259: WIP_DISCRETE_JOBS WIP
11260: WHERE wo.VISIT_ID = c_visit_id
11261: AND wo.VISIT_TASK_ID IS NULL
11262: AND wo.MASTER_WORKORDER_FLAG = 'Y'

Line 12691: FROM WIP_DISCRETE_JOBS WDJ, AHL_WORKORDERS WO

12687:
12688: --fetches the schedule start and completion date of workorder
12689: CURSOR get_wo_schedule_dates_cur(p_wo_id IN NUMBER) IS
12690: SELECT WDJ.SCHEDULED_START_DATE, WDJ.SCHEDULED_COMPLETION_DATE
12691: FROM WIP_DISCRETE_JOBS WDJ, AHL_WORKORDERS WO
12692: WHERE WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID AND
12693: WO.WORKORDER_ID = p_wo_id;
12694: get_wo_schedule_dates_rec get_wo_schedule_dates_cur%ROWTYPE;
12695:

Line 12700: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,

12696: --fetches project task id, the task start and end date of visit task
12697: CURSOR get_task_dates_cur(p_wo_id IN NUMBER) IS
12698: SELECT AVT.PROJECT_TASK_ID, AVT.START_DATE_TIME, AVT.END_DATE_TIME,
12699: PAT.DESCRIPTION -- Pass the old description back again
12700: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,
12701: PA_TASKS PAT
12702: WHERE WO.VISIT_TASK_ID = AVT.VISIT_TASK_ID AND
12703: WO.WORKORDER_ID = p_wo_id AND
12704: PAT.TASK_ID (+) = AVT.PROJECT_TASK_ID;

Line 12712: FROM ahl_workorders wo, ahl_visits_b av

12708: CURSOR get_visit_details_cur (p_wo_id IN NUMBER) IS
12709: --TCHIMIRA::BUG:9117467::23-NOV-2009
12710: --Removed the column wo.workorder_id from the select clause
12711: SELECT av.visit_id, av.project_id, av.start_date_time, av.close_date_time, av.top_project_task_id
12712: FROM ahl_workorders wo, ahl_visits_b av
12713: WHERE WO.WORKORDER_ID = p_wo_id
12714: AND wo.visit_id = av.visit_id;
12715: -- Changed by jaramana on 11-NOV-2009 for bug 9109020
12716: --AND wo.visit_task_id IS NULL

Line 13052: SELECT count(*) FROM AHL_WORKORDERS

13048: c_task_rec c_task%ROWTYPE;
13049:
13050: -- To find count for jobs tasks
13051: CURSOR c_job (x_id IN NUMBER) IS
13052: SELECT count(*) FROM AHL_WORKORDERS
13053: WHERE VISIT_TASK_ID = x_id
13054: AND STATUS_CODE not in ('22','7');
13055:
13056: CURSOR c_chk_job (x_id IN NUMBER) IS

Line 13057: SELECT * FROM AHL_WORKORDERS

13053: WHERE VISIT_TASK_ID = x_id
13054: AND STATUS_CODE not in ('22','7');
13055:
13056: CURSOR c_chk_job (x_id IN NUMBER) IS
13057: SELECT * FROM AHL_WORKORDERS
13058: WHERE VISIT_TASK_ID = x_id
13059: AND STATUS_CODE not in ('22','7');
13060: c_chk_job_rec c_chk_job%ROWTYPE;
13061:

Line 13065: FROM AHL_WORKORDERS

13061:
13062: -- To find job for Visit
13063: CURSOR c_visit_job (x_id IN NUMBER) IS
13064: SELECT workorder_id, object_version_number
13065: FROM AHL_WORKORDERS
13066: WHERE VISIT_ID = x_id
13067: AND VISIT_TASK_ID IS NULL
13068: AND MASTER_WORKORDER_FLAG = 'Y'
13069: AND STATUS_CODE not in ('22','7');

Line 13099: FROM ahl_workorders

13095: WHERE wip_entity_id =
13096: (
13097: SELECT
13098: wip_entity_id
13099: FROM ahl_workorders
13100: WHERE
13101: master_workorder_flag = 'Y' AND
13102: visit_task_id IS null AND
13103: status_code not in (22,7) and

Line 14507: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip

14503:
14504: --fetch master work order for the visit
14505: CURSOR c_visit_master_wo (c_visit_id IN NUMBER) IS
14506: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
14507: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
14508: WHERE v.visit_id = c_visit_id
14509: AND v.visit_id = wo.visit_id
14510: AND wo.visit_task_id IS NULL
14511: AND wo.master_workorder_flag = 'Y'

Line 14527: FROM ahl_workorders wo, wip_discrete_jobs wip

14523:
14524: --fetch work order for the task
14525: CURSOR c_task_wo (c_visit_id IN NUMBER,c_visit_task_id IN NUMBER) IS
14526: SELECT wo.visit_task_id, wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
14527: FROM ahl_workorders wo, wip_discrete_jobs wip
14528: WHERE wo.visit_id = c_visit_id
14529: AND wo.visit_task_id = c_visit_task_id
14530: AND wip.wip_entity_id = wo.wip_entity_id
14531: AND wo.status_code not in ('22','7');

Line 14592: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj

14588: OR (STAGE_ID IS NOT NULL AND TASK_TYPE_CODE = 'STAGE'));
14589:
14590: CURSOR c_visit_time_matches_MWO_time(p_visit_id IN NUMBER) IS
14591: SELECT 1
14592: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj
14593: WHERE vst.visit_id = p_visit_id
14594: AND wo.visit_id = vst.visit_id
14595: AND wo.MASTER_WORKORDER_FLAG = 'Y'
14596: AND wo.visit_task_id IS NULL

Line 14650: FROM ahl_workorders wo

14646:
14647:
14648: Cursor get_task_wo (c_task_id IN NUMBER) IS
14649: SELECT wo.workorder_id
14650: FROM ahl_workorders wo
14651: WHERE wo.visit_task_id = c_task_id;
14652:
14653: l_temp_num1 NUMBER := NULL;
14654: l_temp_num2 NUMBER := NULL;