[Home] [Help] [Dependency Information]
Object Name: | PA_SCHEDULES_HSTRY_AR# |
---|---|
Object Type: | VIEW |
Owner: | PA |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
ASSIGNMENT_ID | NUMBER | |||
CALENDAR_ID | NUMBER | |||
CHANGE_ID | NUMBER | |||
CREATED_BY | NUMBER | (15) | Yes | |
CREATION_DATE | DATE | Yes | ||
END_DATE | DATE | |||
FRIDAY_HOURS | NUMBER | |||
LAST_APPROVED_FLAG | VARCHAR2 | (1) | ||
LAST_UPDATE_BY | NUMBER | (15) | Yes | |
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | (15) | ||
MONDAY_HOURS | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | (15) | ||
PROGRAM_ID | NUMBER | (15) | ||
PROGRAM_UPDATE_DATE | DATE | |||
PROJECT_ID | NUMBER | |||
PURGE_BATCH_ID | NUMBER | (15) | Yes | |
PURGE_PROJECT_ID | NUMBER | (15) | Yes | |
PURGE_RELEASE | VARCHAR2 | (50) | Yes | |
REQUEST_ID | NUMBER | (15) | ||
SATURDAY_HOURS | NUMBER | |||
SCHEDULE_ID | NUMBER | |||
SCHEDULE_TYPE_CODE | VARCHAR2 | (30) | ||
START_DATE | DATE | |||
STATUS_CODE | VARCHAR2 | (30) | ||
SUNDAY_HOURS | NUMBER | |||
THURSDAY_HOURS | NUMBER | |||
TUESDAY_HOURS | NUMBER | |||
WEDNESDAY_HOURS | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT ASSIGNMENT_ID
, CALENDAR_ID
, CHANGE_ID
, CREATED_BY
, CREATION_DATE
, END_DATE
, FRIDAY_HOURS
, LAST_APPROVED_FLAG
, LAST_UPDATE_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, MONDAY_HOURS
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, PROJECT_ID
, PURGE_BATCH_ID
, PURGE_PROJECT_ID
, PURGE_RELEASE
, REQUEST_ID
, SATURDAY_HOURS
, SCHEDULE_ID
, SCHEDULE_TYPE_CODE
, START_DATE
, STATUS_CODE
, SUNDAY_HOURS
, THURSDAY_HOURS
, TUESDAY_HOURS
, WEDNESDAY_HOURS
FROM PA.PA_SCHEDULES_HSTRY_AR#;
|
|
|