MKT_PRFL_ATTRIBUTE

Details

Schema: FUSION
Object owner: MKT
Object type: VIEW

Columns

Name
PRA_ID PR_ID PRA_SYSTEM_NAME PRA_READ_ONLY PRA_PRIMARY_KEY PRA_TYPE PRA_QSL PRA_MB_DATA_TYPE PRA_CARDINALITY PRA_CUSTOM_LOV_METHOD PRA_CREATED_LANG_ID PRA_ACTIVE PRA_CHANGE_NUMBER PRA_OPERATOR_ELEMENT_LIST_ID PRA_ATTRIBUTE_TYPE PRA_MERGE_TYPE PRA_MERGE_DEPENDENT_PRA_ID PRA_DATA_TYPE_CODE PRA_FG_ID PRA_DATA_TYPE PRA_TRACKING_IS_ENABLED PRA_TRACKING_TYPE PRA_ENTITY_TYPE_ID PRA_ENTITY_ID CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER PRA_GUID PRA_CREATED_DATE PRA_CREATED_BY PRA_LAST_MODIFIED_DATE PRA_LAST_MODIFIED_BY PRA_DISPLAY_MERGE_FIELD PRA_SOURCE_AM PRA_SOURCE_VO_INSTANCE PRA_SOURCE_FIELD_NAME PRA_SOURCE_VO_KEY_FLAG PRA_ALT_SOURCE_AM PRA_ALT_SOURCE_VO_INSTANCE PRA_ALT_SOURCE_FIELD_NAME PRA_ALT_VO_KEY_FLAG PRA_CMP_MEMBER_TGT_COL PRA_SOURCE_AM_CONFIG PRA_MERGE_CONFIG PRA_USAGE PRAL_DISPLAY_NAME EXAMPLE

Name

PRA_ID

PR_ID

PRA_SYSTEM_NAME

PRA_READ_ONLY

PRA_PRIMARY_KEY

PRA_TYPE

PRA_QSL

PRA_MB_DATA_TYPE

PRA_CARDINALITY

PRA_CUSTOM_LOV_METHOD

PRA_CREATED_LANG_ID

PRA_ACTIVE

PRA_CHANGE_NUMBER

PRA_OPERATOR_ELEMENT_LIST_ID

PRA_ATTRIBUTE_TYPE

PRA_MERGE_TYPE

PRA_MERGE_DEPENDENT_PRA_ID

PRA_DATA_TYPE_CODE

PRA_FG_ID

PRA_DATA_TYPE

PRA_TRACKING_IS_ENABLED

PRA_TRACKING_TYPE

PRA_ENTITY_TYPE_ID

PRA_ENTITY_ID

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

OBJECT_VERSION_NUMBER

PRA_GUID

PRA_CREATED_DATE

PRA_CREATED_BY

PRA_LAST_MODIFIED_DATE

PRA_LAST_MODIFIED_BY

PRA_DISPLAY_MERGE_FIELD

PRA_SOURCE_AM

PRA_SOURCE_VO_INSTANCE

PRA_SOURCE_FIELD_NAME

PRA_SOURCE_VO_KEY_FLAG

PRA_ALT_SOURCE_AM

PRA_ALT_SOURCE_VO_INSTANCE

PRA_ALT_SOURCE_FIELD_NAME

PRA_ALT_VO_KEY_FLAG

PRA_CMP_MEMBER_TGT_COL

PRA_SOURCE_AM_CONFIG

PRA_MERGE_CONFIG

PRA_USAGE

PRAL_DISPLAY_NAME

EXAMPLE

Query

SQL_Statement
SELECT B.PRA_ID, B.PR_ID, B.PRA_SYSTEM_NAME, B.PRA_READ_ONLY, B.PRA_PRIMARY_KEY, B.PRA_TYPE, B.PRA_QSL, B.PRA_MB_DATA_TYPE, B.PRA_CARDINALITY, B.PRA_CUSTOM_LOV_METHOD, B.PRA_CREATED_LANG_ID, B.PRA_ACTIVE, B.PRA_CHANGE_NUMBER, B.PRA_OPERATOR_ELEMENT_LIST_ID, B.PRA_ATTRIBUTE_TYPE, B.PRA_MERGE_TYPE, B.PRA_MERGE_DEPENDENT_PRA_ID, B.PRA_DATA_TYPE_CODE, B.PRA_FG_ID, B.PRA_DATA_TYPE, B.PRA_TRACKING_IS_ENABLED, B.PRA_TRACKING_TYPE, B.PRA_ENTITY_TYPE_ID, B.PRA_ENTITY_ID, B.CREATED_BY, B.CREATION_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN, B.OBJECT_VERSION_NUMBER, B.PRA_GUID, B.PRA_CREATED_DATE, B.PRA_CREATED_BY, B.PRA_LAST_MODIFIED_DATE, B.PRA_LAST_MODIFIED_BY, B.PRA_DISPLAY_MERGE_FIELD, B.PRA_SOURCE_AM, B.PRA_SOURCE_VO_INSTANCE, B.PRA_SOURCE_FIELD_NAME, B.PRA_SOURCE_VO_KEY_FLAG, B.PRA_ALT_SOURCE_AM, B.PRA_ALT_SOURCE_VO_INSTANCE, B.PRA_ALT_SOURCE_FIELD_NAME, B.PRA_ALT_VO_KEY_FLAG, B.PRA_CMP_MEMBER_TGT_COL, B.PRA_SOURCE_AM_CONFIG, B.PRA_MERGE_CONFIG, B.PRA_USAGE, TL.PRAL_DISPLAY_NAME, TL.EXAMPLE FROM MKT_PRFL_ATTRIBUTE_B B, MKT_PRFL_ATTRIBUTE_TL TL WHERE B.PRA_ID = TL.PRA_ID AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.PRA_ID,

B.PR_ID,

B.PRA_SYSTEM_NAME,

B.PRA_READ_ONLY,

B.PRA_PRIMARY_KEY,

B.PRA_TYPE,

B.PRA_QSL,

B.PRA_MB_DATA_TYPE,

B.PRA_CARDINALITY,

B.PRA_CUSTOM_LOV_METHOD,

B.PRA_CREATED_LANG_ID,

B.PRA_ACTIVE,

B.PRA_CHANGE_NUMBER,

B.PRA_OPERATOR_ELEMENT_LIST_ID,

B.PRA_ATTRIBUTE_TYPE,

B.PRA_MERGE_TYPE,

B.PRA_MERGE_DEPENDENT_PRA_ID,

B.PRA_DATA_TYPE_CODE,

B.PRA_FG_ID,

B.PRA_DATA_TYPE,

B.PRA_TRACKING_IS_ENABLED,

B.PRA_TRACKING_TYPE,

B.PRA_ENTITY_TYPE_ID,

B.PRA_ENTITY_ID,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN,

B.OBJECT_VERSION_NUMBER,

B.PRA_GUID,

B.PRA_CREATED_DATE,

B.PRA_CREATED_BY,

B.PRA_LAST_MODIFIED_DATE,

B.PRA_LAST_MODIFIED_BY,

B.PRA_DISPLAY_MERGE_FIELD,

B.PRA_SOURCE_AM,

B.PRA_SOURCE_VO_INSTANCE,

B.PRA_SOURCE_FIELD_NAME,

B.PRA_SOURCE_VO_KEY_FLAG,

B.PRA_ALT_SOURCE_AM,

B.PRA_ALT_SOURCE_VO_INSTANCE,

B.PRA_ALT_SOURCE_FIELD_NAME,

B.PRA_ALT_VO_KEY_FLAG,

B.PRA_CMP_MEMBER_TGT_COL,

B.PRA_SOURCE_AM_CONFIG,

B.PRA_MERGE_CONFIG,

B.PRA_USAGE,

TL.PRAL_DISPLAY_NAME,

TL.EXAMPLE

FROM

MKT_PRFL_ATTRIBUTE_B B,

MKT_PRFL_ATTRIBUTE_TL TL

WHERE

B.PRA_ID = TL.PRA_ID AND TL.LANGUAGE = USERENV('LANG')