[Home] [Help] [Dependency Information]
Object Name: | OZF_RESALE_DRAFT_LOGS_ALL |
---|---|
Object Type: | TABLE |
Owner: | OZF |
Subobject Name: | |
Status: | VALID |
This table will be used to store the logs for each resale_line_int_id if there are any errors when Third Party Accrual program is run in Draft Mode. This table has some selected columns from OZF_RESALE_LOGS_ALL table along with few new columns
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
RESALE_DRAFT_LOG_ID | VARCHAR2 | (240) | Yes | |
RESALE_ID | NUMBER | Yes | Resale Identifier | |
DRAFT_RUN_ID | NUMBER | Yes | Draft Run Identifier | |
RESALE_ID_TYPE | VARCHAR2 | (30) | Yes | Resale Identifier Type |
ERROR_CODE | VARCHAR2 | (30) | Yes | Error Code |
ERROR_MESSAGE | VARCHAR2 | (2000) | Yes | Error Message |
COLUMN_NAME | VARCHAR2 | (30) | Name of the colum where error occured | |
COLUMN_VALUE | VARCHAR2 | (300) | Value of the column where error occured | |
ORG_ID | NUMBER | Yes | Organization identifier | |
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 | Yes | Standard WHO Column | |
REQUEST_ID | NUMBER | Yes | Request Id | |
PROGRAM_APPLICATION_ID | VARCHAR2 | (240) | Yes | Program application id |
PROGRAM_ID | NUMBER | Yes | Program ID | |
PROGRAM_UPDATE_DATE | DATE | Yes | Program Update Date |
Cut, paste (and edit) the following text to query this object:
SELECT RESALE_DRAFT_LOG_ID
, RESALE_ID
, DRAFT_RUN_ID
, RESALE_ID_TYPE
, ERROR_CODE
, ERROR_MESSAGE
, COLUMN_NAME
, COLUMN_VALUE
, ORG_ID
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM OZF.OZF_RESALE_DRAFT_LOGS_ALL;
OZF.OZF_RESALE_DRAFT_LOGS_ALL does not reference any database object
OZF.OZF_RESALE_DRAFT_LOGS_ALL is referenced by following:
|
|
|