[Home] [Help] [Dependency Information]
Object Name: | CHV_PURGE_SCHEDULE_LIST |
---|---|
Object Type: | TABLE |
Owner: | PO |
FND Design Data: | CHV.CHV_PURGE_SCHEDULE_LIST |
Subobject Name: | |
Status: | VALID |
This table will be populated with a list of planning and shipping
schedules that are purge candidates. When the purge is confirmed, the
schedules in this list and all its related records will be deleted.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CHV_PURGE_SCHEDULE_LIST_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | SCHEDULE_ITEM_ID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
SCHEDULE_ITEM_ID | NUMBER | Yes | Schedule item unique identifier | |
PURGE_NAME | VARCHAR2 | (15) | Yes | Name of the process that purged the schedule list |
DOUBLE_CHECK_FLAG | VARCHAR2 | (1) | Yes | Indicates whether or not the schedule list is still purgeable during confirmation |
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_ITEM_ID
, PURGE_NAME
, DOUBLE_CHECK_FLAG
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM PO.CHV_PURGE_SCHEDULE_LIST;
PO.CHV_PURGE_SCHEDULE_LIST does not reference any database object
PO.CHV_PURGE_SCHEDULE_LIST is referenced by following:
|
|
|