eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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

TABLE: PO.PO_UDA_INTERFACE

Object Details

Object Name:	PO_UDA_INTERFACE
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_UDA_INTERFACE
Subobject Name:
Status:	VALID

Interface table for importing UDA data corresponding to any of the procurement entities enabled for UDAs - PO / Agreement Header, Line Shipment; Requistion Header and Line; Solicitation Header and Line; Offer line.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Columns

Name	Datatype	Length	Comments
TRANSACTION_ID	NUMBER		Interface unique identifier
ROW_IDENTIFIER	NUMBER		Unique identifier to identify all the attribute of a Attribute Group
ATTR_GROUP_ID	NUMBER		Attribute Group unique identifier
ATTR_GROUP_APP_ID	NUMBER		Attribute Groups Application Id
ATTR_GROUP_TYPE	VARCHAR2	(40)	Attribute Group type internal name
ATTR_GROUP_NAME	VARCHAR2	(30)	Attribute Group display name
DATA_LEVEL_1	VARCHAR2	(150)	DATA_LEVEL_1
DATA_LEVEL_2	VARCHAR2	(150)	DATA_LEVEL_2
DATA_LEVEL_3	VARCHAR2	(150)	DATA_LEVEL_3
TRANSACTION_TYPE	VARCHAR2	(10)	Transaction type.
ATTR_NAME	VARCHAR2	(30)	Attributes internal name
ATTR_VALUE_STR	VARCHAR2	(1000)	Attribute Data if the attribute is of String Type
ATTR_VALUE_NUM	NUMBER		Attribute Data if the attribute is of Number Type
ATTR_VALUE_DATE	DATE		Attribute Data if the attribute is of Date Type
ATTR_DISP_VALUE	VARCHAR2	(1000)	Attribute Data if the attribute is of Lov Type
ATTR_UNIT_OF_MEASURE	VARCHAR2	(3)	Attribute Datas UOM
USER_ROW_IDENTIFIER	NUMBER		A unique identifier which can be used
PK1_VALUE	NUMBER		Primary Key value in extension table
PK2_VALUE	NUMBER		Primary Key value in extension table
PK3_VALUE	NUMBER		Primary Key value in extension table
PK4_VALUE	NUMBER		Primary Key value in extension table
PK5_VALUE	NUMBER		Primary Key value in extension table
UDA_TEMPLATE_ID	NUMBER		Attribute template unique identifier
INTERFACE_REFERENCE_ID	NUMBER		Interface Reference ID.
PROCESS_STATUS	NUMBER		Interface record status
PROCESS_PHASE	VARCHAR2	(50)	Interface record current processing status
REQUEST_ID	NUMBER		Concurrent Program who column - concurrent request id of the program that last updated this row (foreign key to FND_CONCURRENT_REQUESTS.REQUEST_ID).
PROGRAM_ID	NUMBER		Concurrent Program who column - program id of the program that last updated this row (foreign key to FND_CONCURRENT_PROGRAM.CONCURRENT_PROGRAM_ID).
PROGRAM_APPLICATION_ID	NUMBER		Concurrent Program who column - application id of the program that last updated this row (foreign key to FND_APPLICATION.APPLICATION_ID).
PROGRAM_UPDATE_DATE	DATE		Concurrent Program who column - date when a program last updated this row).
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
CREATION_DATE	DATE		Standard who column - date when this row was created.
LAST_UPDATE_LOGIN	NUMBER		Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATED_BY	NUMBER		Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
LAST_UPDATED_BY	NUMBER		Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY_NAME	VARCHAR2	(100)	Who column - Name of the user who created this row
LAST_UPDATED_BY_NAME	VARCHAR2	(100)	Who column - Name of the user who last updated this row
INTERFACE_SOURCE_CODE	VARCHAR2	(100)	Stores Interface source code.
INTERFACE_SOURCE_LINE_ID	NUMBER		Source line id.
INTERFACE_LINE_ID	NUMBER		Interface Line ID

Query Text

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


SELECT TRANSACTION_ID
,      ROW_IDENTIFIER
,      ATTR_GROUP_ID
,      ATTR_GROUP_APP_ID
,      ATTR_GROUP_TYPE
,      ATTR_GROUP_NAME
,      DATA_LEVEL_1
,      DATA_LEVEL_2
,      DATA_LEVEL_3
,      TRANSACTION_TYPE
,      ATTR_NAME
,      ATTR_VALUE_STR
,      ATTR_VALUE_NUM
,      ATTR_VALUE_DATE
,      ATTR_DISP_VALUE
,      ATTR_UNIT_OF_MEASURE
,      USER_ROW_IDENTIFIER
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      UDA_TEMPLATE_ID
,      INTERFACE_REFERENCE_ID
,      PROCESS_STATUS
,      PROCESS_PHASE
,      REQUEST_ID
,      PROGRAM_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_UPDATE_DATE
,      LAST_UPDATE_DATE
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      LAST_UPDATED_BY
,      CREATED_BY_NAME
,      LAST_UPDATED_BY_NAME
,      INTERFACE_SOURCE_CODE
,      INTERFACE_SOURCE_LINE_ID
,      INTERFACE_LINE_ID
FROM PO.PO_UDA_INTERFACE;

Dependencies

[top of page]

PO.PO_UDA_INTERFACE does not reference any database object

PO.PO_UDA_INTERFACE is referenced by following:

PO: PO_UDA_INTERFACE#