QP_PRICING_PARAMETERS_VL
Details
-
Schema: FUSION
-
Object owner: QP
-
Object type: VIEW
Columns
Name |
---|
PARAMETER_ID PARAMETER_CODE PARAMETER_LEVEL_CODE DOMAIN_SOURCE_CODE LAST_UPDATE_LOGIN LAST_UPDATED_BY LAST_UPDATE_DATE CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER NAME DESCRIPTION PARAMETER_USAGE_CODE |
Query
SQL_Statement |
---|
SELECT QP_PRICING_PARAMETERS_B.PARAMETER_ID PARAMETER_ID, QP_PRICING_PARAMETERS_B.PARAMETER_CODE PARAMETER_CODE, QP_PRICING_PARAMETERS_B.PARAMETER_LEVEL_CODE PARAMETER_LEVEL_CODE, QP_PRICING_PARAMETERS_B.DOMAIN_SOURCE_CODE DOMAIN_SOURCE_CODE, QP_PRICING_PARAMETERS_B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QP_PRICING_PARAMETERS_B.LAST_UPDATED_BY LAST_UPDATED_BY, QP_PRICING_PARAMETERS_B.LAST_UPDATE_DATE LAST_UPDATE_DATE, QP_PRICING_PARAMETERS_B.CREATED_BY CREATED_BY, QP_PRICING_PARAMETERS_B.CREATION_DATE CREATION_DATE, QP_PRICING_PARAMETERS_B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, QP_PRICING_PARAMETERS_TL.NAME NAME, QP_PRICING_PARAMETERS_TL.DESCRIPTION DESCRIPTION, QP_PRICING_PARAMETERS_B.PARAMETER_USAGE_CODE PARAMETER_USAGE_CODE FROM QP_PRICING_PARAMETERS_B, QP_PRICING_PARAMETERS_TL WHERE QP_PRICING_PARAMETERS_B.PARAMETER_ID = QP_PRICING_PARAMETERS_TL.PARAMETER_ID AND QP_PRICING_PARAMETERS_TL.LANGUAGE = USERENV('LANG') |