1. Tables and Views for Project Management
  2. PJT_SCHEDULES_VL

PJT_SCHEDULES_VL

Details

  • Schema: FUSION

  • Object owner: PJT

  • Object type: VIEW

Columns

Name

SCHEDULE_NAME

SCHEDULE_ID

OBJECT_VERSION_NUMBER

SCHEDULE_TYPE_CODE

EFFECTIVE_FROM_DATE

EFFECTIVE_TO_DATE

SCHEDULE_DESC

QTRLY_TYPE_CODE

CATEGORY_CODE

ASSIGNMENT_NUM

Query

SQL_Statement

SELECT zmm.SCHEDULE_NAME,

zmm.SCHEDULE_ID,

zmm.OBJECT_VERSION_NUMBER,

zmm.SCHEDULE_TYPE_CODE,

zmm.EFFECTIVE_FROM_DATE,

zmm.EFFECTIVE_TO_DATE,

zmm.SCHEDULE_DESC ,

zmm.QTRLY_TYPE_CODE,

zmm.CATEGORY_CODE,

zmm.ASSIGNMENT_NUM

FROM ZMM_SR_SCHEDULES_VL zmm

WHERE trunc(sysdate) BETWEEN zmm.EFFECTIVE_FROM_DATE AND zmm.EFFECTIVE_TO_DATE

and SCHEDULE_TYPE_CODE='ELAPSED'

union

select

lookup.meaning schedule_name,

-99 schedule_id,

null ,

'ELAPSED' schedule_type_code,

to_date('30/12/1869','DD/MM/YYYY') effective_from_date,

to_date('07/01/2970','DD/MM/YYYY') effective_to_date,

lookup.description schedule_desc ,

null ,

null ,

null

from fnd_lookups lookup

where lookup_type='PJT_PSEUDO_CALENDAR'

and lookup_code='PJT_PSEUDO_CALENDAR_NAME'