View: QP_PTE_REQUEST_TYPES_V

Product:	QP - Advanced Pricing
Description:	This view contains all the Pricing Transaction entities with all the Request types associated with it. It stores all global information about the Request type and translated description of the Request type.
Implementation/DBA Data:	APPS.QP_PTE_REQUEST_TYPES_V

View Text

SELECT B.REQUEST_TYPE_CODE
, B.PTE_CODE
, B.ORDER_LEVEL_GLOBAL_STRUCT
, B.LINE_LEVEL_GLOBAL_STRUCT
, B.ORDER_LEVEL_VIEW_NAME
, B.LINE_LEVEL_VIEW_NAME
, B.ENABLED_FLAG
, B.CONTEXT
, B.ATTRIBUTE1
, B.ATTRIBUTE2
, B.ATTRIBUTE3
, B.ATTRIBUTE4
, B.ATTRIBUTE5
, B.ATTRIBUTE6
, B.ATTRIBUTE7
, B.ATTRIBUTE8
, B.ATTRIBUTE9
, B.ATTRIBUTE10
, B.ATTRIBUTE11
, B.ATTRIBUTE12
, B.ATTRIBUTE13
, B.ATTRIBUTE14
, B.ATTRIBUTE15
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
, B.PROGRAM_APPLICATION_ID
, B.PROGRAM_ID
, B.PROGRAM_UPDATE_DATE
, T.REQUEST_TYPE_DESC
FROM QP_PTE_REQUEST_TYPES_B B
, QP_PTE_REQUEST_TYPES_TL T
WHERE B.REQUEST_TYPE_CODE = T.REQUEST_TYPE_CODE
AND T.LANGUAGE = USERENV('LANG')

Columns