Product: | IBY - Payments |
---|---|
Description: | |
Implementation/DBA Data: | APPS.IBY_G_MSG_TEMPLATES_VL |
SELECT MTB.ROWID ROW_ID
, MTB.MSG_TEMPLATE_ID
, MTB.OBJECT_VERSION_NUMBER
, MTB.CREATED_BY
, MTB.CREATION_DATE
, MTB.LAST_UPDATED_BY
, MTB.LAST_UPDATE_DATE
, MTB.LAST_UPDATE_LOGIN
, MTB.MSG_TEMPLATE_NAME
, MTB.MSG_TEMPLATE_NUMBER
, MTB.MSG_TEMPLATE_VERSION
, MTB.MSG_TYPE_CODE
, FLU.MEANING MSG_TYPE_MEANING
, MTB.FROZEN_FLAG
, MTB.SEEDED_FLAG
, MTB.START_DATE_ACTIVE
, MTB.END_DATE_ACTIVE
, MTB.SECURITY_GROUP_ID
, MTB.ATTRIBUTE_CATEGORY
, MTB.ATTRIBUTE1
, MTB.ATTRIBUTE2
, MTB.ATTRIBUTE3
, MTB.ATTRIBUTE4
, MTB.ATTRIBUTE5
, MTB.ATTRIBUTE6
, MTB.ATTRIBUTE7
, MTB.ATTRIBUTE8
, MTB.ATTRIBUTE9
, MTB.ATTRIBUTE10
, MTB.ATTRIBUTE11
, MTB.ATTRIBUTE12
, MTB.ATTRIBUTE13
, MTB.ATTRIBUTE14
, MTB.ATTRIBUTE15
, MTTL.NAME
, MTTL.DESCRIPTION
, MTTL.MESSAGE_TEMPLATE FROM IBY_G_MSG_TEMPLATES_B MTB
, IBY_G_MSG_TEMPLATES_TL MTTL
, FND_LOOKUPS FLU
WHERE MTB.MSG_TEMPLATE_ID = MTTL.MSG_TEMPLATE_ID
AND MTTL.LANGUAGE = USERENV('LANG')
AND MTB.MSG_TYPE_CODE = FLU.LOOKUP_CODE
AND FLU.LOOKUP_TYPE = 'IBY_G_MSG_TEMPLATE_TYPE'