QP_PB_MESSAGES_VL

Details

• Schema: FUSION

• Object owner: QP

• Object type: VIEW

Columns

Name
PB_MESSAGE_ID PB_REQUEST_ID PRICE_BOOK_ID MESSAGE_TYPE_CODE MESSAGE_NAME PARENT_ENTITY_CODE PARENT_ENTITY_ID MESSAGE_SOURCE_CODE MESSAGE_TOKEN_INFO CREATION_DATE CREATED_BY LAST_UPDATED_BY LAST_UPDATE_DATE LAST_UPDATE_LOGIN OBJECT_VERSION_NUMBER MESSAGE_TEXT MESSAGE_USER_DETAILS

Query

SQL_Statement

SELECT QP_PB_MESSAGES_B.PB_MESSAGE_ID PB_MESSAGE_ID, QP_PB_MESSAGES_B.PB_REQUEST_ID PB_REQUEST_ID, QP_PB_MESSAGES_B.PRICE_BOOK_ID PRICE_BOOK_ID, QP_PB_MESSAGES_B.MESSAGE_TYPE_CODE MESSAGE_TYPE_CODE, QP_PB_MESSAGES_B.MESSAGE_NAME MESSAGE_NAME, QP_PB_MESSAGES_B.PARENT_ENTITY_CODE PARENT_ENTITY_CODE, QP_PB_MESSAGES_B.PARENT_ENTITY_ID PARENT_ENTITY_ID, QP_PB_MESSAGES_B.MESSAGE_SOURCE_CODE MESSAGE_SOURCE_CODE, QP_PB_MESSAGES_B.MESSAGE_TOKEN_INFO MESSAGE_TOKEN_INFO, QP_PB_MESSAGES_B.CREATION_DATE CREATION_DATE, QP_PB_MESSAGES_B.CREATED_BY CREATED_BY, QP_PB_MESSAGES_B.LAST_UPDATED_BY LAST_UPDATED_BY, QP_PB_MESSAGES_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_PB_MESSAGES_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_PB_MESSAGES_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QP_PB_MESSAGES_TL.MESSAGE_TEXT MESSAGE_TEXT, QP_PB_MESSAGES_TL.MESSAGE_USER_DETAILS MESSAGE_USER_DETAILS FROM QP_PB_MESSAGES_B, QP_PB_MESSAGES_TL WHERE QP_PB_MESSAGES_B.PB_MESSAGE_ID = QP_PB_MESSAGES_TL.PB_MESSAGE_ID AND QP_PB_MESSAGES_TL.LANGUAGE = USERENV('LANG')