APPS.AHL_VWP_PROJ_PROD_PVT dependencies on WIP_DISCRETE_JOBS

Line 4044: WIP_DISCRETE_JOBS WIP

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

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

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

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

7106: IS
7107: SELECT
7108: scheduled_start_date,
7109: SCHEDULED_COMPLETION_DATE
7110: FROM wip_discrete_jobs
7111: WHERE wip_entity_id =
7112: (
7113: SELECT
7114: wip_entity_id

Line 7802: FROM wip_discrete_jobs

7798: IS
7799: SELECT
7800: scheduled_start_date,
7801: SCHEDULED_COMPLETION_DATE
7802: FROM wip_discrete_jobs
7803: WHERE wip_entity_id =
7804: (
7805: SELECT
7806: wip_entity_id

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

9119: CURSOR c_get_wo_details(x_visit_id IN NUMBER)
9120: IS
9121: SELECT scheduled_start_date,
9122: SCHEDULED_COMPLETION_DATE
9123: FROM wip_discrete_jobs
9124: WHERE wip_entity_id =
9125: (
9126: SELECT
9127: wip_entity_id