DBA Data[Home] [Help] [Dependency Information]

TABLE: PO.PO_VALIDATION_RESULTS_GT

Object Details
Object Name: PO_VALIDATION_RESULTS_GT
Object Type: TABLE
Owner: PO
FND Design Data: TablePO.PO_VALIDATION_RESULTS_GT
Subobject Name:
Status: VALID

Temporary Table Details

PO.PO_VALIDATION_RESULTS_GT is a global temporary table. The current session is able see data that it placed in the table but other sessions cannot. Data in the table is temporary. It has a data duration of SYS$SESSION. Data is removed at the end of this period.

Storage Details
Tablespace: Tablespace
PCT Free: 10
PCT Used: 40
Columns
Name Datatype Length Mandatory Comments
RESULT_SET_ID NUMBER

RESULT_TYPE VARCHAR2 (30)
ENTITY_TYPE VARCHAR2 (30)
ENTITY_ID NUMBER

ENTITY_INTERFACE_ID NUMBER

COLUMN_NAME VARCHAR2 (30)
COLUMN_VAL VARCHAR2 (4000)
MESSAGE_APPLICATION VARCHAR2 (30)
MESSAGE_NAME VARCHAR2 (30)
TOKEN1_NAME VARCHAR2 (30)
TOKEN1_VALUE VARCHAR2 (4000)
TOKEN2_NAME VARCHAR2 (30)
TOKEN2_VALUE VARCHAR2 (4000)
TOKEN3_NAME VARCHAR2 (30)
TOKEN3_VALUE VARCHAR2 (4000)
TOKEN4_NAME VARCHAR2 (30)
TOKEN4_VALUE VARCHAR2 (4000)
TOKEN5_NAME VARCHAR2 (30)
TOKEN5_VALUE VARCHAR2 (4000)
TOKEN6_NAME VARCHAR2 (30)
TOKEN6_VALUE VARCHAR2 (4000)
VALIDATION_ID NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT RESULT_SET_ID
,      RESULT_TYPE
,      ENTITY_TYPE
,      ENTITY_ID
,      ENTITY_INTERFACE_ID
,      COLUMN_NAME
,      COLUMN_VAL
,      MESSAGE_APPLICATION
,      MESSAGE_NAME
,      TOKEN1_NAME
,      TOKEN1_VALUE
,      TOKEN2_NAME
,      TOKEN2_VALUE
,      TOKEN3_NAME
,      TOKEN3_VALUE
,      TOKEN4_NAME
,      TOKEN4_VALUE
,      TOKEN5_NAME
,      TOKEN5_VALUE
,      TOKEN6_NAME
,      TOKEN6_VALUE
,      VALIDATION_ID
FROM PO.PO_VALIDATION_RESULTS_GT;

Dependencies

[top of page]

PO.PO_VALIDATION_RESULTS_GT does not reference any database object

PO.PO_VALIDATION_RESULTS_GT is referenced by following:

SchemaAPPS
SynonymPO_VALIDATION_RESULTS_GT