VIEW: APPS.OE_PC_VTMPLT_COLS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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