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