1. Tables and Views for HCM
  2. CEL_PROGRAM_CARDS_VL

CEL_PROGRAM_CARDS_VL

Details

  • Schema: FUSION

  • Object owner: CEL

  • Object type: VIEW

Columns

Name

CARD_ID

PROGRAM_ID

ILLUSTRATION_ID

VALUE_ID

POINTS

CARD_HEADLINE

CARD_MESSAGE

OBJECT_VERSION_NUMBER

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement

SELECT B.CARD_ID,

B.PROGRAM_ID,

B.ILLUSTRATION_ID,

B.VALUE_ID,

B.POINTS,

T.CARD_HEADLINE,

T.CARD_MESSAGE,

B.OBJECT_VERSION_NUMBER,

B.CREATED_BY,

B.CREATION_DATE,

B.LAST_UPDATED_BY,

B.LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN

FROM CEL_PROGRAM_CARDS_B B, CEL_PROGRAM_CARDS_TL T WHERE B.CARD_ID = T.CARD_ID AND T.LANGUAGE = USERENV('LANG')