[Home] [Help] [Dependency Information]
Object Name: | CHV_HISTORY_SCHEDULES# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ID | NUMBER | Yes | ||
VENDOR_ID | NUMBER | |||
VENDOR_SITE_ID | NUMBER | |||
SCHEDULE_TYPE | VARCHAR2 | (25) | ||
SCHEDULE_SUBTYPE | VARCHAR2 | (25) | ||
SCHEDULE_HORIZON_START | DATE | |||
BUCKET_PATTERN_ID | NUMBER | |||
CREATION_DATE | DATE | |||
SCHEDULE_NUM | VARCHAR2 | (20) | ||
SCHEDULE_REVISION | NUMBER | |||
SCHEDULE_STATUS | VARCHAR2 | (25) | ||
ITEM_ID | NUMBER | |||
ORGANIZATION_ID | NUMBER | |||
PURGE_NAME | VARCHAR2 | (15) | ||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE |
Cut, paste (and edit) the following text to query this object:
SELECT SCHEDULE_ID
, VENDOR_ID
, VENDOR_SITE_ID
, SCHEDULE_TYPE
, SCHEDULE_SUBTYPE
, SCHEDULE_HORIZON_START
, BUCKET_PATTERN_ID
, CREATION_DATE
, SCHEDULE_NUM
, SCHEDULE_REVISION
, SCHEDULE_STATUS
, ITEM_ID
, ORGANIZATION_ID
, PURGE_NAME
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM PO.CHV_HISTORY_SCHEDULES#;
|
|
|