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

TABLE: RRS.RRS_LOCATION_UA_INTF

Object Details
Object Name: RRS_LOCATION_UA_INTF
Object Type: TABLE
Owner: RRS
FND Design Data: TableRRS.RRS_LOCATION_UA_INTF
Subobject Name:
Status: VALID


This table is for internal use and it is used for webADI integration.


Storage Details
Tablespace: TablespaceAPPS_TS_TX_DATA
PCT Free: 10
PCT Used:
Columns
Name Datatype Length Mandatory Comments
TRANSACTION_ID NUMBER
Yes Uniquely identifies each record in this table.
DATA_LEVEL_ID NUMBER

Refers to data level identifier of the association. Column in ego_data_level_b
DATA_LEVEL_NAME VARCHAR2 (30)
Refers to data_level_name of the association. References data_level_name from ego_data_level_b.
USER_DATA_LEVEL_NAME VARCHAR2 (240)
User Name for Data Level to be displayed to the end user.
PROCESS_STATUS VARCHAR2 (15)
Identifies the status of the concurrent request used by webADI integration.
DATA_SET_ID NUMBER

An identifier for the collection of rows to be processed together
ROW_IDENTIFIER NUMBER

Identifier column for the record.
ATTR_GROUP_INT_NAME VARCHAR2 (30)
Attribute Group Internal Name.
ATTR_INT_NAME VARCHAR2 (30)
Attribute Internal Name.
ATTR_VALUE_STR VARCHAR2 (1000)
Attribute Value. Hold values of type VARCHAR.
ATTR_VALUE_NUM NUMBER

Attribute Value. Hold values of type NUMBER.
ATTR_VALUE_DATE DATE

Attribute Name. Hold values of type DATE.
ATTR_DISP_VALUE VARCHAR2 (1000)
Attribute Display Value.
TRANSACTION_TYPE VARCHAR2 (10)
Transaction Type. Possible values CREATE,UPDFATE,DELETE.
LOCATION_ID VARCHAR2 (150)
Unique Identifier of the Location.
ATTR_GROUP_ID NUMBER

Unique identfier for trade areas group id.
COUNTRY VARCHAR2 (150)
Indicates the COUNTRY
REQUEST_ID NUMBER

Concurrent Requst id.
PROGRAM_APPLICATION_ID NUMBER

Concurrent Programs Application Id.
PROGRAM_ID NUMBER

Concurrent Program Id.
PROGRAM_UPDATE_DATE DATE

Standard columns.
CREATED_BY NUMBER

Standard who columns.
CREATION_DATE DATE

Standard who columns.
LAST_UPDATED_BY NUMBER

Standard who columns.
LAST_UPDATE_DATE DATE

Standard who columns.
LAST_UPDATE_LOGIN NUMBER

Standard who columns.
ATTR_GROUP_TYPE VARCHAR2 (30)
Attribute Group Type of the attribute
ATTR_UOM_DISP_VALUE VARCHAR2 (25)
Display value of Unit Of Measure associated with attribute.
ATTR_VALUE_UOM VARCHAR2 (3)
Internal value of Unit Of Measure associated with attribute.
Query Text

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


SELECT TRANSACTION_ID
,      DATA_LEVEL_ID
,      DATA_LEVEL_NAME
,      USER_DATA_LEVEL_NAME
,      PROCESS_STATUS
,      DATA_SET_ID
,      ROW_IDENTIFIER
,      ATTR_GROUP_INT_NAME
,      ATTR_INT_NAME
,      ATTR_VALUE_STR
,      ATTR_VALUE_NUM
,      ATTR_VALUE_DATE
,      ATTR_DISP_VALUE
,      TRANSACTION_TYPE
,      LOCATION_ID
,      ATTR_GROUP_ID
,      COUNTRY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      ATTR_GROUP_TYPE
,      ATTR_UOM_DISP_VALUE
,      ATTR_VALUE_UOM
FROM RRS.RRS_LOCATION_UA_INTF;

Dependencies

[top of page]

RRS.RRS_LOCATION_UA_INTF does not reference any database object

RRS.RRS_LOCATION_UA_INTF is referenced by following:

SchemaAPPS
SynonymRRS_LOCATION_UA_INTF