QP_PRICING_PARAMETERS_VL
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: QP
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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') |