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 3415: FROM AHL_WORKORDERS

3411: ) IS
3412:
3413: CURSOR get_mwo_wip_entity_id(x_visit_id IN NUMBER) IS
3414: SELECT wip_entity_id
3415: FROM AHL_WORKORDERS
3416: WHERE visit_id = x_visit_id
3417: AND VISIT_TASK_ID IS NULL
3418: AND MASTER_WORKORDER_FLAG = 'Y';
3419:

Line 3433: SELECT 1 FROM AHL_WORKORDERS

3429: WHERE PARENT.visit_task_id = CHILD.originating_task_id
3430: AND CHILD.visit_task_id = c_visit_task_id;
3431:
3432: CURSOR does_wo_exist_csr(c_visit_task_id NUMBER) IS
3433: SELECT 1 FROM AHL_WORKORDERS
3434: WHERE VISIT_TASK_ID = c_visit_task_id;
3435:
3436: CURSOR get_wip_entity_id(c_visit_task_id NUMBER) IS
3437: SELECT wip_entity_id FROM AHL_WORKORDERS

Line 3437: SELECT wip_entity_id FROM AHL_WORKORDERS

3433: SELECT 1 FROM AHL_WORKORDERS
3434: WHERE VISIT_TASK_ID = c_visit_task_id;
3435:
3436: CURSOR get_wip_entity_id(c_visit_task_id NUMBER) IS
3437: SELECT wip_entity_id FROM AHL_WORKORDERS
3438: WHERE VISIT_TASK_ID = c_visit_task_id;
3439:
3440: L_API_NAME CONSTANT VARCHAR2(30) := 'Get_Task_Relationships';
3441: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;

Line 3627: FROM AHL_WORKORDERS

3623:
3624: CURSOR get_wo(c_visit_task_id NUMBER)
3625: IS
3626: SELECT wip_entity_id
3627: FROM AHL_WORKORDERS
3628: WHERE VISIT_TASK_ID = c_visit_task_id
3629: AND STATUS_CODE NOT IN ('22','7');
3630:
3631: CURSOR get_parent_wo(c_visit_task_id NUMBER)

Line 3634: FROM AHL_WORKORDERS

3630:
3631: CURSOR get_parent_wo(c_visit_task_id NUMBER)
3632: IS
3633: SELECT wip_entity_id
3634: FROM AHL_WORKORDERS
3635: WHERE VISIT_TASK_ID = c_visit_task_id
3636: AND STATUS_CODE NOT IN ('22','7');
3637: -- yazhou 27-Jun-2006 ends
3638:

Line 3642: FROM AHL_WORKORDERS

3638:
3639: CURSOR get_mwo(c_visit_id NUMBER)
3640: IS
3641: SELECT wip_entity_id
3642: FROM AHL_WORKORDERS
3643: WHERE visit_id = c_visit_id
3644: AND VISIT_TASK_ID IS NULL
3645: AND MASTER_WORKORDER_FLAG = 'Y'
3646: AND STATUS_CODE NOT IN ('7', '22');

Line 4032: FROM AHL_WORKORDERS

4028: /* Begin Changes by Shkalyan */
4029: -- To find job for task
4030: CURSOR c_job (x_id IN NUMBER) IS
4031: SELECT workorder_id, object_version_number, status_code
4032: FROM AHL_WORKORDERS
4033: WHERE VISIT_TASK_ID = x_id
4034: AND STATUS_CODE not in ('22','7'); --(22-Deleted, 7-Cancelled)
4035:
4036: --transit check visit change

Line 4043: FROM AHL_WORKORDERS WO,

4039: CURSOR c_visit_job (x_visit_id IN NUMBER) IS
4040: SELECT wo.workorder_id, wo.object_version_number, wo.status_code,
4041: WIP.SCHEDULED_START_DATE,
4042: WIP.SCHEDULED_COMPLETION_DATE
4043: FROM AHL_WORKORDERS WO,
4044: WIP_DISCRETE_JOBS WIP
4045: WHERE wo.VISIT_ID = x_visit_id
4046: AND wo.VISIT_TASK_ID IS NULL
4047: AND wo.MASTER_WORKORDER_FLAG = 'Y'

Line 4053: FROM AHL_WORKORDERS WO

4049: AND wo.STATUS_CODE not in ('22','7'); --(22-Deleted, 7-Cancelled)
4050:
4051: CURSOR c_visit_wo_status (x_visit_id IN NUMBER) IS
4052: SELECT wo.status_code
4053: FROM AHL_WORKORDERS WO
4054: WHERE wo.VISIT_ID = x_visit_id
4055: AND wo.VISIT_TASK_ID IS NULL
4056: AND wo.MASTER_WORKORDER_FLAG = 'Y'
4057: AND wo.STATUS_CODE not in ('22','7'); --(22-Deleted, 7-Cancelled)

Line 4062: FROM AHL_WORKORDERS WO,

4058:
4059: -- Get workorder status for the coresponding job in originating visit
4060: CURSOR c_wo_status (x_orig_visit_id IN NUMBER, x_visit_task_id IN NUMBER) IS
4061: SELECT wo.status_code
4062: FROM AHL_WORKORDERS WO,
4063: AHL_VISIT_TASKS_B t
4064: WHERE wo.VISIT_ID = x_orig_visit_id
4065: AND wo.visit_task_id = t.visit_task_id
4066: AND t.visit_task_number = (Select visit_task_number

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

5829:
5830: --cursor to fetch master work order for the visit
5831: CURSOR c_fet_master_wo (x_visit_id IN NUMBER) IS
5832: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date
5833: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
5834: WHERE v.visit_id = x_visit_id
5835: AND NVL(v.status_code,'X') = 'PARTIALLY RELEASED'
5836: AND v.visit_id = wo.visit_id
5837: AND wo.visit_task_id IS NULL

Line 6214: SELECT 1 FROM ahl_workorders wo

6210: ) IS
6211:
6212: --check if the visit master wo exists
6213: CURSOR c_fet_master_wo (x_visit_id IN NUMBER) IS
6214: SELECT 1 FROM ahl_workorders wo
6215: WHERE wo.visit_id = x_visit_id
6216: AND wo.visit_task_id IS NULL
6217: AND wo.master_workorder_flag = 'Y';
6218:

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

6218:
6219: --fetch master work order for the visit
6220: CURSOR c_visit_master_wo (x_visit_id IN NUMBER) IS
6221: SELECT wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
6222: FROM ahl_visits_b v, ahl_workorders wo, wip_discrete_jobs wip
6223: WHERE v.visit_id = x_visit_id
6224: AND v.visit_id = wo.visit_id
6225: AND wo.visit_task_id IS NULL
6226: AND wo.master_workorder_flag = 'Y'

Line 6248: SELECT 1 FROM ahl_workorders wo

6244: c_visit_tsk_dtl_rec c_visit_task_dtl%ROWTYPE;
6245:
6246: --check if the task wo exists
6247: CURSOR c_fet_task_wo (x_visit_id IN NUMBER, x_visit_task_id IN NUMBER) IS
6248: SELECT 1 FROM ahl_workorders wo
6249: WHERE wo.visit_id = x_visit_id
6250: AND wo.visit_task_id = x_visit_task_id
6251: AND wo.visit_task_id IS NOT NULL;
6252:

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

6252:
6253: --fetch work order for the task
6254: CURSOR c_task_wo (x_visit_id IN NUMBER,x_visit_task_id IN NUMBER) IS
6255: SELECT v.visit_task_id, wo.workorder_id, wo.status_code, wip.scheduled_start_date,wip.scheduled_completion_date,wo.object_version_number
6256: FROM ahl_visit_tasks_b v, ahl_workorders wo, wip_discrete_jobs wip
6257: WHERE v.visit_id = x_visit_id
6258: AND v.visit_id = wo.visit_id
6259: AND wo.visit_task_id IS NOT NULL
6260: AND wo.visit_task_id = x_visit_task_id

Line 6293: FROM ahl_workorders wo

6289:
6290: --check if the visit master wo exists
6291: CURSOR c_fet_mas_wo_dtls (x_visit_id IN NUMBER) IS
6292: SELECT actual_start_date,actual_end_date
6293: FROM ahl_workorders wo
6294: WHERE wo.visit_id = x_visit_id
6295: AND wo.visit_task_id IS NULL
6296: AND wo.master_workorder_flag = 'Y';
6297:

Line 6328: FROM AHL_WORKORDERS AWO,

6324: AWO.WORKORDER_ID,
6325: AWO.OBJECT_VERSION_NUMBER,
6326: WDJ.SCHEDULED_START_DATE,
6327: WDJ.SCHEDULED_COMPLETION_DATE
6328: FROM AHL_WORKORDERS AWO,
6329: WIP_DISCRETE_JOBS WDJ
6330: WHERE WDJ.WIP_ENTITY_ID = AWO.WIP_ENTITY_ID
6331: AND AWO.VISIT_TASK_ID = p_sr_task_id
6332: AND AWO.MASTER_WORKORDER_FLAG = 'Y'

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

6351: AND status_code = 'PLANNING';
6352:
6353: CURSOR c_visit_time_matches_MWO_time(p_visit_id IN NUMBER) IS
6354: SELECT 1
6355: FROM ahl_visits_b vst, ahl_workorders wo, wip_discrete_jobs wdj
6356: WHERE vst.visit_id = p_visit_id
6357: AND wo.visit_id = vst.visit_id
6358: AND wo.MASTER_WORKORDER_FLAG = 'Y'
6359: AND wo.visit_task_id IS NULL

Line 7097: FROM AHL_WORKORDERS

7093: c_visit_rec c_visit%ROWTYPE;
7094:
7095: CURSOR get_wo(c_visit_id NUMBER, c_unit_effectivity_id NUMBER) IS
7096: SELECT workorder_id
7097: FROM AHL_WORKORDERS
7098: WHERE VISIT_TASK_ID = (select visit_task_id from ahl_visit_tasks_b
7099: where visit_id = c_visit_id
7100: and unit_effectivity_id = c_unit_effectivity_id
7101: AND NVL(status_code, 'Y') <> 'DELETED'

Line 7115: FROM ahl_workorders

7111: WHERE wip_entity_id =
7112: (
7113: SELECT
7114: wip_entity_id
7115: FROM ahl_workorders
7116: WHERE
7117: master_workorder_flag = 'Y' AND
7118: visit_task_id IS null AND
7119: status_code not in (22,7) and

Line 7537: FROM AHL_WORKORDERS

7533:
7534: CURSOR get_wo(c_visit_task_id NUMBER)
7535: IS
7536: SELECT wip_entity_id
7537: FROM AHL_WORKORDERS
7538: WHERE VISIT_TASK_ID = c_visit_task_id
7539: AND STATUS_CODE NOT IN ('7', '22');
7540:
7541: CURSOR get_parent_wo(c_visit_task_id NUMBER)

Line 7544: FROM AHL_WORKORDERS

7540:
7541: CURSOR get_parent_wo(c_visit_task_id NUMBER)
7542: IS
7543: SELECT wip_entity_id
7544: FROM AHL_WORKORDERS
7545: WHERE VISIT_TASK_ID = c_visit_task_id
7546: AND STATUS_CODE NOT IN ('7', '22');
7547:
7548: CURSOR get_mwo(c_visit_id NUMBER)

Line 7551: FROM AHL_WORKORDERS

7547:
7548: CURSOR get_mwo(c_visit_id NUMBER)
7549: IS
7550: SELECT wip_entity_id
7551: FROM AHL_WORKORDERS
7552: WHERE visit_id = c_visit_id
7553: AND VISIT_TASK_ID IS NULL
7554: AND MASTER_WORKORDER_FLAG = 'Y'
7555: AND STATUS_CODE NOT IN ('7', '22');

Line 7807: FROM ahl_workorders

7803: WHERE wip_entity_id =
7804: (
7805: SELECT
7806: wip_entity_id
7807: FROM ahl_workorders
7808: WHERE
7809: master_workorder_flag = 'Y' AND
7810: visit_task_id IS null AND
7811: status_code not in (22,7) and

Line 8864: FROM WIP_DISCRETE_JOBS WDJ, AHL_WORKORDERS WO

8860:
8861: --fetches the schedule start and completion date of workorder
8862: CURSOR get_wo_schedule_dates_cur(p_wo_id IN NUMBER) IS
8863: SELECT WDJ.SCHEDULED_START_DATE, WDJ.SCHEDULED_COMPLETION_DATE
8864: FROM WIP_DISCRETE_JOBS WDJ, AHL_WORKORDERS WO
8865: WHERE WDJ.WIP_ENTITY_ID = WO.WIP_ENTITY_ID AND
8866: WO.WORKORDER_ID = p_wo_id;
8867: get_wo_schedule_dates_rec get_wo_schedule_dates_cur%ROWTYPE;
8868:

Line 8873: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,

8869: --fetches project task id, the task start and end date of visit task
8870: CURSOR get_task_dates_cur(p_wo_id IN NUMBER) IS
8871: SELECT AVT.PROJECT_TASK_ID, AVT.START_DATE_TIME, AVT.END_DATE_TIME,
8872: PAT.DESCRIPTION -- Pass the old description back again
8873: FROM AHL_VISIT_TASKS_B AVT, AHL_WORKORDERS WO,
8874: PA_TASKS PAT
8875: WHERE WO.VISIT_TASK_ID = AVT.VISIT_TASK_ID AND
8876: WO.WORKORDER_ID = p_wo_id AND
8877: PAT.TASK_ID (+) = AVT.PROJECT_TASK_ID;

Line 8883: FROM ahl_workorders wo, ahl_visits_b av

8879:
8880: --fetch the project id, visit start date and visit end date
8881: CURSOR get_visit_details_cur (p_wo_id IN NUMBER) IS
8882: SELECT wo.workorder_id, av.visit_id, av.project_id, av.start_date_time, av.close_date_time
8883: FROM ahl_workorders wo, ahl_visits_b av
8884: WHERE WO.WORKORDER_ID = p_wo_id
8885: AND wo.visit_id = av.visit_id
8886: AND wo.visit_task_id IS NULL
8887: AND wo.master_workorder_flag = 'Y';

Line 9083: SELECT count(*) FROM AHL_WORKORDERS

9079: c_task_rec c_task%ROWTYPE;
9080:
9081: -- To find count for jobs tasks
9082: CURSOR c_job (x_id IN NUMBER) IS
9083: SELECT count(*) FROM AHL_WORKORDERS
9084: WHERE VISIT_TASK_ID = x_id
9085: AND STATUS_CODE not in ('22','7');
9086:
9087: CURSOR c_chk_job (x_id IN NUMBER) IS

Line 9088: SELECT * FROM AHL_WORKORDERS

9084: WHERE VISIT_TASK_ID = x_id
9085: AND STATUS_CODE not in ('22','7');
9086:
9087: CURSOR c_chk_job (x_id IN NUMBER) IS
9088: SELECT * FROM AHL_WORKORDERS
9089: WHERE VISIT_TASK_ID = x_id
9090: AND STATUS_CODE not in ('22','7');
9091: c_chk_job_rec c_chk_job%ROWTYPE;
9092:

Line 9096: FROM AHL_WORKORDERS

9092:
9093: -- To find job for Visit
9094: CURSOR c_visit_job (x_id IN NUMBER) IS
9095: SELECT workorder_id, object_version_number
9096: FROM AHL_WORKORDERS
9097: WHERE VISIT_ID = x_id
9098: AND VISIT_TASK_ID IS NULL
9099: AND MASTER_WORKORDER_FLAG = 'Y'
9100: AND STATUS_CODE not in ('22','7');

Line 9128: FROM ahl_workorders

9124: WHERE wip_entity_id =
9125: (
9126: SELECT
9127: wip_entity_id
9128: FROM ahl_workorders
9129: WHERE
9130: master_workorder_flag = 'Y' AND
9131: visit_task_id IS null AND
9132: status_code not in (22,7) and