IRC_WABA_TEMPLATE_DETAILS

Details

Schema: FUSION
Object owner: IRC
Object type: VIEW

Columns

Name
WA_TEMPLATE_ID WABA_TEMPLATE_ID WABA_TEMPLATE_NAME WA_TEMPLATE_DISPLAY_NAME TEMPLATE_STATUS WABA_TEMPLATE_STATUS REJECTION_REASON DECISION_DATE DESCRIPTION_TYPE_CODE WABA_CATEGORY WABA_TEMPLATE_CONTENT LANGUAGE DESC_VERSION_ID PRODUCT_CONTEXT TEMPLATE_SOURCE CREATED_BY CREATION_DATE LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN

Name

WA_TEMPLATE_ID

WABA_TEMPLATE_ID

WABA_TEMPLATE_NAME

WA_TEMPLATE_DISPLAY_NAME

TEMPLATE_STATUS

WABA_TEMPLATE_STATUS

REJECTION_REASON

DECISION_DATE

DESCRIPTION_TYPE_CODE

WABA_CATEGORY

WABA_TEMPLATE_CONTENT

LANGUAGE

DESC_VERSION_ID

PRODUCT_CONTEXT

TEMPLATE_SOURCE

CREATED_BY

CREATION_DATE

LAST_UPDATED_BY

LAST_UPDATE_DATE

LAST_UPDATE_LOGIN

Query

SQL_Statement
SELECT B.WA_TEMPLATE_ID WA_TEMPLATE_ID, DETAILS.WABA_TEMPLATE_ID WABA_TEMPLATE_ID, B.WABA_TEMPLATE_NAME WABA_TEMPLATE_NAME, TL.WA_TEMPLATE_DISPLAY_NAME WA_TEMPLATE_DISPLAY_NAME, B.TEMPLATE_STATUS TEMPLATE_STATUS, DETAILS.WABA_TEMPLATE_STATUS WABA_TEMPLATE_STATUS, DETAILS.REJECTION_REASON REJECTION_REASON, DETAILS.DECISION_DATE DECISION_DATE, B.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE, B.WABA_CATEGORY WABA_CATEGORY, TL.WABA_TEMPLATE_CONTENT WABA_TEMPLATE_CONTENT, TL.LANGUAGE LANGUAGE, B.DESC_VERSION_ID DESC_VERSION_ID, B.PRODUCT_CONTEXT PRODUCT_CONTEXT, B.TEMPLATE_SOURCE TEMPLATE_SOURCE, B.CREATED_BY CREATED_BY, B.CREATION_DATE CREATION_DATE, B.LAST_UPDATED_BY LAST_UPDATED_BY, B.LAST_UPDATE_DATE LAST_UPDATE_DATE, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN FROM IRC_WHATSAPP_TEMPLATE_B B, IRC_WABA_TEMPLATE_DETAILS DETAILS, IRC_WHATSAPP_TEMPLATE_TL TL WHERE B.WA_TEMPLATE_ID = TL.WA_TEMPLATE_ID AND B.WA_TEMPLATE_ID = DETAILS.WA_TEMPLATE_ID AND DETAILS.TEMPLATE_LANGUAGE = TL.LANGUAGE AND TL.LANGUAGE = USERENV('LANG')

SQL_Statement

SELECT

B.WA_TEMPLATE_ID WA_TEMPLATE_ID,

DETAILS.WABA_TEMPLATE_ID WABA_TEMPLATE_ID,

B.WABA_TEMPLATE_NAME WABA_TEMPLATE_NAME,

TL.WA_TEMPLATE_DISPLAY_NAME WA_TEMPLATE_DISPLAY_NAME,

B.TEMPLATE_STATUS TEMPLATE_STATUS,

DETAILS.WABA_TEMPLATE_STATUS WABA_TEMPLATE_STATUS,

DETAILS.REJECTION_REASON REJECTION_REASON,

DETAILS.DECISION_DATE DECISION_DATE,

B.DESCRIPTION_TYPE_CODE DESCRIPTION_TYPE_CODE,

B.WABA_CATEGORY WABA_CATEGORY,

TL.WABA_TEMPLATE_CONTENT WABA_TEMPLATE_CONTENT,

TL.LANGUAGE LANGUAGE,

B.DESC_VERSION_ID DESC_VERSION_ID,

B.PRODUCT_CONTEXT PRODUCT_CONTEXT,

B.TEMPLATE_SOURCE TEMPLATE_SOURCE,

B.CREATED_BY CREATED_BY,

B.CREATION_DATE CREATION_DATE,

B.LAST_UPDATED_BY LAST_UPDATED_BY,

B.LAST_UPDATE_DATE LAST_UPDATE_DATE,

B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN

FROM

IRC_WHATSAPP_TEMPLATE_B B,

IRC_WABA_TEMPLATE_DETAILS DETAILS,

IRC_WHATSAPP_TEMPLATE_TL TL

WHERE B.WA_TEMPLATE_ID = TL.WA_TEMPLATE_ID

AND B.WA_TEMPLATE_ID = DETAILS.WA_TEMPLATE_ID

AND DETAILS.TEMPLATE_LANGUAGE = TL.LANGUAGE

AND TL.LANGUAGE = USERENV('LANG')