[Home] [Help] [Dependency Information]
Object Name: | PO_INTERFACE_ERRORS# |
---|---|
Object Type: | VIEW |
Owner: | PO |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INTERFACE_TYPE | VARCHAR2 | (25) | Yes | |
INTERFACE_TRANSACTION_ID | NUMBER | Yes | ||
COLUMN_NAME | VARCHAR2 | (30) | ||
ERROR_MESSAGE | VARCHAR2 | (2000) | ||
PROCESSING_DATE | DATE | |||
CREATION_DATE | DATE | Yes | ||
CREATED_BY | NUMBER | Yes | ||
LAST_UPDATE_DATE | DATE | Yes | ||
LAST_UPDATED_BY | NUMBER | Yes | ||
LAST_UPDATE_LOGIN | NUMBER | |||
REQUEST_ID | NUMBER | |||
PROGRAM_APPLICATION_ID | NUMBER | |||
PROGRAM_ID | NUMBER | |||
PROGRAM_UPDATE_DATE | DATE | |||
ERROR_MESSAGE_NAME | VARCHAR2 | (30) | ||
TABLE_NAME | VARCHAR2 | (30) | ||
BATCH_ID | NUMBER | |||
INTERFACE_HEADER_ID | NUMBER | |||
INTERFACE_LINE_ID | NUMBER | |||
INTERFACE_DISTRIBUTION_ID | NUMBER | |||
COLUMN_VALUE | VARCHAR2 | (4000) | ||
INTERFACE_LINE_LOCATION_ID | NUMBER | |||
INTERFACE_ATTR_VALUES_ID | NUMBER | |||
INTERFACE_ATTR_VALUES_TLP_ID | NUMBER | |||
PRICE_DIFF_INTERFACE_ID | NUMBER | |||
TOKEN1_NAME | VARCHAR2 | (100) | ||
TOKEN1_VALUE | VARCHAR2 | (200) | ||
TOKEN2_NAME | VARCHAR2 | (100) | ||
TOKEN2_VALUE | VARCHAR2 | (200) | ||
TOKEN3_NAME | VARCHAR2 | (100) | ||
TOKEN3_VALUE | VARCHAR2 | (200) | ||
TOKEN4_NAME | VARCHAR2 | (100) | ||
TOKEN4_VALUE | VARCHAR2 | (200) | ||
TOKEN5_NAME | VARCHAR2 | (100) | ||
TOKEN5_VALUE | VARCHAR2 | (200) | ||
TOKEN6_NAME | VARCHAR2 | (100) | ||
TOKEN6_VALUE | VARCHAR2 | (200) | ||
APP_NAME | VARCHAR2 | (50) |
Cut, paste (and edit) the following text to query this object:
SELECT INTERFACE_TYPE
, INTERFACE_TRANSACTION_ID
, COLUMN_NAME
, ERROR_MESSAGE
, PROCESSING_DATE
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, ERROR_MESSAGE_NAME
, TABLE_NAME
, BATCH_ID
, INTERFACE_HEADER_ID
, INTERFACE_LINE_ID
, INTERFACE_DISTRIBUTION_ID
, COLUMN_VALUE
, INTERFACE_LINE_LOCATION_ID
, INTERFACE_ATTR_VALUES_ID
, INTERFACE_ATTR_VALUES_TLP_ID
, PRICE_DIFF_INTERFACE_ID
, TOKEN1_NAME
, TOKEN1_VALUE
, TOKEN2_NAME
, TOKEN2_VALUE
, TOKEN3_NAME
, TOKEN3_VALUE
, TOKEN4_NAME
, TOKEN4_VALUE
, TOKEN5_NAME
, TOKEN5_VALUE
, TOKEN6_NAME
, TOKEN6_VALUE
, APP_NAME
FROM PO.PO_INTERFACE_ERRORS#;
|
|
|