[Home] [Help] [Dependency Information]
Object Name: | ASP_PROGRAM_RUN_DATES |
---|---|
Object Type: | TABLE |
Owner: | ASP |
Subobject Name: | |
Status: | VALID |
Holds Last Program Run Dates
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
ASP_PROGRAM_RUN_DATES_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX | PROGRAM_RUN_ID |
ASP_PROGRAM_RUN_DATES_N1 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
PROGRAM_OBJECT_CODE
STATUS_CODE |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
PROGRAM_RUN_ID | NUMBER | Yes | Last run program Identifier | |
PROGRAM_OBJECT_CODE | VARCHAR2 | (30) | Yes | Last Run Program Code |
STATUS_CODE | VARCHAR2 | (1) | Yes | Status Code of the program run |
DESCRIPTION | VARCHAR2 | (240) | Short Description about the program | |
PROGRAM_START_DATE | DATE | Yes | Start date of the last program run | |
PROGRAM_END_DATE | DATE | End date of the last program run | ||
PROGRAM_REF_DATE | DATE | Reference Date of the last program run used for present run comparison | ||
RELATED_OBJECT_INFO | VARCHAR2 | (2000) | Last run program object information | |
REQUEST_ID | NUMBER | Request of the last concurrent program run | ||
PROGRAM_APPLICATION_ID | NUMBER | Application Id of the last run concurrent program | ||
PROGRAM_ID | NUMBER | Program Id of the last run concurrent program | ||
PROGRAM_LOGIN_ID | NUMBER | Login Id of the last run concurrent program | ||
OBJECT_VERSION_NUMBER | NUMBER | Yes | Change Indicator | |
CREATION_DATE | DATE | Yes | Standard WHO column | |
CREATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_DATE | DATE | Yes | Standard WHO column | |
LAST_UPDATED_BY | NUMBER | Yes | Standard WHO column | |
LAST_UPDATE_LOGIN | NUMBER | Standard WHO column |
Cut, paste (and edit) the following text to query this object:
SELECT PROGRAM_RUN_ID
, PROGRAM_OBJECT_CODE
, STATUS_CODE
, DESCRIPTION
, PROGRAM_START_DATE
, PROGRAM_END_DATE
, PROGRAM_REF_DATE
, RELATED_OBJECT_INFO
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_LOGIN_ID
, OBJECT_VERSION_NUMBER
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
FROM ASP.ASP_PROGRAM_RUN_DATES;
ASP.ASP_PROGRAM_RUN_DATES does not reference any database object
ASP.ASP_PROGRAM_RUN_DATES is referenced by following:
|
|
|