APPS.AHL_PRD_WORKORDER_PVT dependencies on WIP_DISCRETE_JOBS

Line 680: WIP_DISCRETE_JOBS

676: SELECT
677: TO_CHAR(scheduled_start_date, 'ss') schedule_start_sec,
678: TO_CHAR(scheduled_completion_date, 'ss') schedule_end_sec
679: FROM
680: WIP_DISCRETE_JOBS
681: WHERE
682: WIP_ENTITY_ID = c_wip_entity_id;
683:
684: -- Balaji added for Release NR error

Line 916: WIP_DISCRETE_JOBS WIP

912: WIP.SCHEDULED_START_DATE,
913: WIP.SCHEDULED_COMPLETION_DATE,
914: WIP.OWNING_DEPARTMENT
915: FROM AHL_WORKORDERS AWOS,
916: WIP_DISCRETE_JOBS WIP
917: WHERE AWOS.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID
918: AND AWOS.workorder_id = c_workorder_id;
919:
920: l_old_workorder_rec get_old_wo_values%ROWTYPE;

Line 1029: FROM WIP_DISCRETE_JOBS WDJ,

1025: CURSOR get_visit_wo_dates(c_visit_id NUMBER)
1026: IS
1027: SELECT WDJ.scheduled_start_date,
1028: WDJ.scheduled_completion_date
1029: FROM WIP_DISCRETE_JOBS WDJ,
1030: AHL_WORKORDERS WO
1031: WHERE WDJ.wip_entity_id = WO.wip_entity_id
1032: AND WO.visit_task_id IS NULL
1033: AND WO.master_workorder_flag = 'Y'

Line 3371: WIP_DISCRETE_JOBS wipj

3367: WO.actual_start_date,
3368: WO.actual_end_date
3369: FROM AHL_WORKORDERS WO,
3370: WIP_SCHED_RELATIONSHIPS WOR,
3371: WIP_DISCRETE_JOBS wipj
3372: WHERE
3373: WIPJ.wip_entity_id = WO.wip_entity_id
3374: AND WO.wip_entity_id = WOR.parent_object_id
3375: AND WO.master_workorder_flag = 'Y'

Line 3390: FROM WIP_DISCRETE_JOBS WDJ,

3386: WDJ.scheduled_completion_date scheduled_end_date,
3387: WO.actual_start_date actual_start_date,
3388: WO.actual_end_date actual_end_date,
3389: WO.status_code status_code
3390: FROM WIP_DISCRETE_JOBS WDJ,
3391: AHL_WORKORDERS WO
3392: WHERE WDJ.wip_entity_id = WO.wip_entity_id
3393: AND WO.status_code <> G_JOB_STATUS_DELETED
3394: AND WO.wip_entity_id in

Line 6194: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ

6190: -- cursor to check if all workorders in a visit are cancelled.
6191: CURSOR chk_cmplt_wo_exists(c_wip_entity_id NUMBER )
6192: IS
6193: SELECT 'x'
6194: FROM AHL_WORKORDERS AWO, WIP_DISCRETE_JOBS WDJ
6195: WHERE awo.wip_entity_id = wdj.wip_entity_id
6196: AND wdj.date_completed IS NOT NULL
6197: --AND master_workorder_flag = 'N'
6198: --AND status_code NOT IN ('7', '22', '12')

Line 7467: WIP_DISCRETE_JOBS WIP

7463: AWO.STATUS_CODE,
7464: WIP.SCHEDULED_START_DATE,
7465: WIP.SCHEDULED_COMPLETION_DATE
7466: FROM AHL_WORKORDERS AWO,
7467: WIP_DISCRETE_JOBS WIP
7468: WHERE AWO.VISIT_ID=c_visit_id
7469: AND AWO.VISIT_TASK_ID IS NULL
7470: AND AWO.MASTER_WORKORDER_FLAG = 'Y'
7471: AND AWO.WIP_ENTITY_ID = WIP.WIP_ENTITY_ID

Line 7480: FROM wip_discrete_jobs

7476: CURSOR get_latest_schedule_dates(c_wip_entity_id IN NUMBER)
7477: IS
7478: SELECT scheduled_start_date,
7479: scheduled_completion_date
7480: FROM wip_discrete_jobs
7481: WHERE wip_entity_id = c_wip_entity_id;
7482:
7483: latest_schedule_dates_rec get_latest_schedule_dates%ROWTYPE;
7484: