1. Tables and Views for Loyalty
  2. LOY_ATTRDEFN_VL

LOY_ATTRDEFN_VL

Details

  • Schema: FUSION

  • Object owner: LOY

  • Object type: VIEW

Columns

Name

LOY_ATTRDEFN_B_ID

CREATED_BY

LAST_UPDATED_BY

LAST_UPDATE_LOGIN

CREATION_DATE

LAST_UPDATE_DATE

CONFLICT_ID

ACCNT_ACT_CODE

ACTIVE_FLAG

ATTR_DEFN_ID

ATTR_TYPE_CODE

BUS_SVC_NAME

CANCEL_ACTN_CODE

COST_PER_PT

CURCY_CODE

CURCY_EXCH_DT

DATA_TYPE_CODE

DEFAULT_VAL

DESC_TEXT

DISPLAY_FLAG

DYNAMIC_FLAG

EXPIRY_ALIGN_CODE

EXPIRY_BASIS_CODE

EXPIRY_DAY_CODE

EXPIRY_MONTH_CODE

EXP_PD_UOM_CODE

EXP_PERIOD_LEN

INTERNAL_NAME

MERGE_ACTION_CODE

METHOD_NAME

MIN_REACTIVATN_QTY

MONTHS_LEN

OBJECT_CODE

PICK_APPLET

PICK_FIELD

PICK_FIELD_NAME

PICK_LIST

PRG_FORMULA_ID

PROGRAM_ID

PROMOTION_ID

QUAL_POINT_FLAG

REACTIVATE_FLAG

READONLY_FLAG

RET_EFF_FLAG

RPT_EXP_PD_UOM_CODE

RPT_EXP_PERIOD_LEN

TIER_CLASS_ID

WEIGHT_FACTOR

WEIGHT_FACTOR_NQ

OBJECT_VERSION_NUMBER

DISPLAY_NAME

Query

SQL_Statement

SELECT

LOY_ATTRDEFN_B.LOY_ATTRDEFN_B_ID,

LOY_ATTRDEFN_B.CREATED_BY,

LOY_ATTRDEFN_B.LAST_UPDATED_BY,

LOY_ATTRDEFN_B.LAST_UPDATE_LOGIN,

LOY_ATTRDEFN_B.CREATION_DATE,

LOY_ATTRDEFN_B.LAST_UPDATE_DATE,

LOY_ATTRDEFN_B.CONFLICT_ID,

LOY_ATTRDEFN_B.ACCNT_ACT_CODE,

LOY_ATTRDEFN_B.ACTIVE_FLAG,

LOY_ATTRDEFN_B.ATTR_DEFN_ID,

LOY_ATTRDEFN_B.ATTR_TYPE_CODE,

LOY_ATTRDEFN_B.BUS_SVC_NAME,

LOY_ATTRDEFN_B.CANCEL_ACTN_CODE,

LOY_ATTRDEFN_B.COST_PER_PT,

LOY_ATTRDEFN_B.CURCY_CODE,

LOY_ATTRDEFN_B.CURCY_EXCH_DT,

LOY_ATTRDEFN_B.DATA_TYPE_CODE,

LOY_ATTRDEFN_B.DEFAULT_VAL,

LOY_ATTRDEFN_B.DESC_TEXT,

LOY_ATTRDEFN_B.DISPLAY_FLAG,

LOY_ATTRDEFN_B.DYNAMIC_FLAG,

LOY_ATTRDEFN_B.EXPIRY_ALIGN_CODE,

LOY_ATTRDEFN_B.EXPIRY_BASIS_CODE,

LOY_ATTRDEFN_B.EXPIRY_DAY_CODE,

LOY_ATTRDEFN_B.EXPIRY_MONTH_CODE,

LOY_ATTRDEFN_B.EXP_PD_UOM_CODE,

LOY_ATTRDEFN_B.EXP_PERIOD_LEN,

LOY_ATTRDEFN_B.INTERNAL_NAME,

LOY_ATTRDEFN_B.MERGE_ACTION_CODE,

LOY_ATTRDEFN_B.METHOD_NAME,

LOY_ATTRDEFN_B.MIN_REACTIVATN_QTY,

LOY_ATTRDEFN_B.MONTHS_LEN,

LOY_ATTRDEFN_B.OBJECT_CODE,

LOY_ATTRDEFN_B.PICK_APPLET,

LOY_ATTRDEFN_B.PICK_FIELD,

LOY_ATTRDEFN_B.PICK_FIELD_NAME,

LOY_ATTRDEFN_B.PICK_LIST,

LOY_ATTRDEFN_B.PRG_FORMULA_ID,

LOY_ATTRDEFN_B.PROGRAM_ID,

LOY_ATTRDEFN_B.PROMOTION_ID,

LOY_ATTRDEFN_B.QUAL_POINT_FLAG,

LOY_ATTRDEFN_B.REACTIVATE_FLAG,

LOY_ATTRDEFN_B.READONLY_FLAG,

LOY_ATTRDEFN_B.RET_EFF_FLAG,

LOY_ATTRDEFN_B.RPT_EXP_PD_UOM_CODE,

LOY_ATTRDEFN_B.RPT_EXP_PERIOD_LEN,

LOY_ATTRDEFN_B.TIER_CLASS_ID,

LOY_ATTRDEFN_B.WEIGHT_FACTOR,

LOY_ATTRDEFN_B.WEIGHT_FACTOR_NQ,

LOY_ATTRDEFN_B.OBJECT_VERSION_NUMBER,

LOY_ATTRDEFN_TL.DISPLAY_NAME

FROM

LOY_ATTRDEFN_TL ,

LOY_ATTRDEFN_B

WHERE

LOY_ATTRDEFN_B.LOY_ATTRDEFN_B_ID = LOY_ATTRDEFN_TL.LOY_ATTRDEFN_B_ID AND LOY_ATTRDEFN_TL.LANGUAGE = USERENV('LANG')