1. Tables and Views for Project Management
  2. PJT_ZMM_SCHEDULE_DTLS_V

PJT_ZMM_SCHEDULE_DTLS_V

Details

  • Schema: FUSION

  • Object owner: PJT

  • Object type: VIEW

Columns

Name

SCHEDULE_ID

SCHEDULE_NAME

START_DATE

HOURS

Query

SQL_Statement

SELECT sch_hdr.schedule_id ,

null schedule_name ,

sch_dtl.start_date_time AS start_date ,

shifts.duration_ms_num/1000/60/60 hours

FROM ZMM_SR_SCHEDULES_B sch_hdr ,

ZMM_SR_SCHEDULE_DTLS sch_dtl ,

ZMM_SR_SHIFTS_B shifts

WHERE sch_hdr.schedule_type_code = 'ELAPSED'

AND sch_hdr.schedule_id = sch_dtl.schedule_id

AND sch_dtl.Shift_Id = shifts.Shift_Id

AND shifts.Availability_Code= 'WORK_PERIOD'

UNION ALL

SELECT -99 schedule_id

, 'DUMMY SCHEDULE' schedule_name

, trunc(sysdate-rownum) start_date

, decode(rtrim(to_char(trunc(sysdate-rownum), 'D')), '2', 8, '3', 8, '4', 8, '5', 8, '6', 8, '7', 0, '1', 0) hours

FROM fnd_lookup_values_b

WHERE lookup_type like 'PJ%'

AND rownum < 120

UNION ALL

SELECT -99 schedule_id

, 'DUMMY SCHEDULE' schedule_name

, trunc(sysdate+rownum-1) start_date

, decode(rtrim(to_char(trunc(sysdate+rownum-1), 'D')), '2', 8, '3', 8, '4', 8, '5', 8, '6', 8, '7', 0, '1', 0) hours

FROM fnd_lookup_values_b

WHERE lookup_type like 'PJ%'

AND rownum < 366*2