Product: | ONT - Order Management |
---|---|
Description: | This view stores columns for the validation templates. |
Implementation/DBA Data: | APPS.OE_PC_VTMPLT_COLS_V |
SELECT VTC.ROWID ROW_ID
, VTC.VALIDATION_TMPLT_COL_ID
, VTC.VALIDATION_TMPLT_ID
, VTC.COLUMN_NAME
, AK.ATTRIBUTE_LABEL_LONG
, AK.DATA_TYPE
, VTC.VALIDATION_OP
, VTC.VALUE_STRING
, VTC.CREATED_BY
, VTC.CREATION_DATE
, VTC.LAST_UPDATED_BY
, VTC.LAST_UPDATE_DATE
, VTC.LAST_UPDATE_LOGIN
FROM OE_PC_VTMPLT_COLS VTC
, OE_PC_VTMPLTS V
, OE_AK_OBJECTS_EXT E
, AK_OBJECT_ATTRIBUTES_VL AK
WHERE VTC.VALIDATION_TMPLT_ID = V.VALIDATION_TMPLT_ID
AND V.ENTITY_ID = E.ENTITY_ID
AND E.APPLICATION_ID = AK.ATTRIBUTE_APPLICATION_ID
AND E.DATABASE_OBJECT_NAME = AK.DATABASE_OBJECT_NAME
AND VTC.COLUMN_NAME = AK.COLUMN_NAME