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]

VIEW: POS.POS_SUPP_PROF_EXT_INTF#

Object Details

Object Name:	POS_SUPP_PROF_EXT_INTF#
Object Type:	VIEW
Owner:	POS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
TRANSACTION_ID	NUMBER		Yes
PROCESS_STATUS	VARCHAR2	(15)	Yes
TRANSACTION_TYPE	VARCHAR2	(10)
ROW_IDENTIFIER	NUMBER		Yes
DATA_SET_ID	NUMBER		Yes
DATA_LEVEL_NAME	VARCHAR2	(50)	Yes
PARTY_ID	NUMBER		Yes
ATTR_GROUP_INT_NAME	VARCHAR2	(30)	Yes
ATTR_INT_NAME	VARCHAR2	(30)	Yes
ATTR_VALUE_STR	VARCHAR2	(1000)
ATTR_VALUE_NUM	NUMBER
ATTR_VALUE_DATE	DATE
ATTR_DISP_VALUE	VARCHAR2	(1000)
ATTR_GROUP_ID	NUMBER
DATA_LEVEL_ID	NUMBER
ATTR_GROUP_TYPE	VARCHAR2	(30)
USER_DATA_LEVEL_NAME	VARCHAR2	(100)
IS_PROSPECT	VARCHAR2	(1)
CLASSIFICATION_CODE	VARCHAR2	(240)
PK1_VALUE	VARCHAR2	(256)
PK2_VALUE	VARCHAR2	(256)
PK3_VALUE	VARCHAR2	(256)
PK4_VALUE	VARCHAR2	(256)
PK5_VALUE	VARCHAR2	(256)
LAST_UPDATE_DATE	DATE
LAST_UPDATED_BY	NUMBER
LAST_UPDATE_LOGIN	NUMBER
CREATED_BY	NUMBER
CREATION_DATE	DATE
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
BATCH_ID	NUMBER
ATTR_VALUE_UOM	VARCHAR2	(3)
ATTR_UOM_DISP_VALUE	VARCHAR2	(25)

Query Text

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


SELECT TRANSACTION_ID
,      PROCESS_STATUS
,      TRANSACTION_TYPE
,      ROW_IDENTIFIER
,      DATA_SET_ID
,      DATA_LEVEL_NAME
,      PARTY_ID
,      ATTR_GROUP_INT_NAME
,      ATTR_INT_NAME
,      ATTR_VALUE_STR
,      ATTR_VALUE_NUM
,      ATTR_VALUE_DATE
,      ATTR_DISP_VALUE
,      ATTR_GROUP_ID
,      DATA_LEVEL_ID
,      ATTR_GROUP_TYPE
,      USER_DATA_LEVEL_NAME
,      IS_PROSPECT
,      CLASSIFICATION_CODE
,      PK1_VALUE
,      PK2_VALUE
,      PK3_VALUE
,      PK4_VALUE
,      PK5_VALUE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATED_BY
,      CREATION_DATE
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      BATCH_ID
,      ATTR_VALUE_UOM
,      ATTR_UOM_DISP_VALUE
FROM POS.POS_SUPP_PROF_EXT_INTF#;

Dependencies

[top of page]

POS.POS_SUPP_PROF_EXT_INTF# references the following:

POS: POS_SUPP_PROF_EXT_INTF

POS.POS_SUPP_PROF_EXT_INTF# is referenced by following:

APPS: POS_SUPP_PROF_EXT_INTF