[Home] [Help]
View: OE_PC_RSET_SEL_COLS_V
Product: | ONT - Order Management |
Description: | This view stores the columns to be matched for the record set. |
Implementation/DBA Data: |
APPS.OE_PC_RSET_SEL_COLS_V
|
View Text
SELECT RSC.ROWID ROW_ID
, RSC.RECORD_SET_ID
, RSC.COLUMN_NAME
, AK.ATTRIBUTE_LABEL_LONG
, RSC.CREATED_BY
, RSC.CREATION_DATE
, RSC.LAST_UPDATED_BY
, RSC.LAST_UPDATE_DATE
, RSC.LAST_UPDATE_LOGIN
FROM OE_PC_RSET_SEL_COLS RSC
, OE_PC_RSETS R
, OE_AK_OBJECTS_EXT E
, AK_OBJECT_ATTRIBUTES_VL AK
WHERE RSC.RECORD_SET_ID = R.RECORD_SET_ID
AND R.ENTITY_ID = E.ENTITY_ID
AND E.APPLICATION_ID = AK.ATTRIBUTE_APPLICATION_ID
AND E.DATABASE_OBJECT_NAME = AK.DATABASE_OBJECT_NAME
AND RSC.COLUMN_NAME = AK.COLUMN_NAME
Columns
Name |
ROW_ID |
RECORD_SET_ID |
COLUMN_NAME |
COLUMN_DISPLAY_NAME |
CREATED_BY |
CREATION_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATE_LOGIN |