[Home] [Help] [Dependency Information]
Object Name: | CHV_HISTORY_SCHEDULES |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | CHV.CHV_HISTORY_SCHEDULES |
Subobject Name: | |
Status: | VALID |
Historical information about the schedules deleted
by the Purge routine are stored in this table.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CHV_HISTORY_SCHEDULES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | ITEM_ID |
CHV_HISTORY_SCHEDULES_N2 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | VENDOR_ID |
CHV_HISTORY_SCHEDULE_N3 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | SCHEDULE_HORIZON_START |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ID | NUMBER | Yes | Schedule unique identifier | |
VENDOR_ID | NUMBER | Supplier unique identifier | ||
VENDOR_SITE_ID | NUMBER | Supplier site unique identifier | ||
SCHEDULE_TYPE | VARCHAR2 | (25) | Planning or shipping schedule | |
SCHEDULE_SUBTYPE | VARCHAR2 | (25) | Type of planning or shipping schedule | |
SCHEDULE_HORIZON_START | DATE | Schedule horizon start date | ||
BUCKET_PATTERN_ID | NUMBER | Bucket pattern for schedule | ||
CREATION_DATE | DATE | Standard Who column | ||
SCHEDULE_NUM | VARCHAR2 | (20) | Schedule number | |
SCHEDULE_REVISION | NUMBER | Schedule revision | ||
SCHEDULE_STATUS | VARCHAR2 | (25) | Confirmed status | |
ITEM_ID | NUMBER | Item | ||
ORGANIZATION_ID | NUMBER | Schedule organization | ||
PURGE_NAME | VARCHAR2 | (15) | Name of the process that purged the schedule | |
REQUEST_ID | NUMBER | Standard Who column | ||
PROGRAM_APPLICATION_ID | NUMBER | Standard Who column | ||
PROGRAM_ID | NUMBER | Standard Who column | ||
PROGRAM_UPDATE_DATE | DATE | Standard Who column |
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;
PO.CHV_HISTORY_SCHEDULES does not reference any database object
PO.CHV_HISTORY_SCHEDULES is referenced by following:
|
|
|