APPS.AHL_VWP_PROJ_PROD_PVT dependencies on WIP_DISCRETE_JOBS

Line 6180: WIP_DISCRETE_JOBS WIP

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'
6184: AND WIP.WIP_ENTITY_ID = WO.WIP_ENTITY_ID

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 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 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 9358: WIP_DISCRETE_JOBS WDJ

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'
9362: AND AWO.STATUS_CODE <> 17;

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 10431: FROM wip_discrete_jobs

10427: IS
10428: SELECT
10429: scheduled_start_date,
10430: SCHEDULED_COMPLETION_DATE
10431: FROM wip_discrete_jobs
10432: WHERE wip_entity_id =
10433: (
10434: SELECT
10435: wip_entity_id

Line 11221: FROM wip_discrete_jobs

11217: IS
11218: SELECT
11219: scheduled_start_date,
11220: SCHEDULED_COMPLETION_DATE
11221: FROM wip_discrete_jobs
11222: WHERE wip_entity_id =
11223: (
11224: SELECT
11225: wip_entity_id

Line 11259: WIP_DISCRETE_JOBS WIP

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'
11263: AND WIP.WIP_ENTITY_ID = WO.WIP_ENTITY_ID

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 13094: FROM wip_discrete_jobs

13090: CURSOR c_get_wo_details(x_visit_id IN NUMBER)
13091: IS
13092: SELECT scheduled_start_date,
13093: SCHEDULED_COMPLETION_DATE
13094: FROM wip_discrete_jobs
13095: WHERE wip_entity_id =
13096: (
13097: SELECT
13098: wip_entity_id

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