DBA Data[Home] [Help]

VIEW: APPS.QP_PARAMETERS_VL

Source

View Text - Preformatted

SELECT B.RoWid ROW_ID, B.parameter_id , B.parameter_level, B.parameter_code, B.value_set_id , B.Advanced_Pricing_Only , B.Seeded_Value , B.Creation_date, B.Created_By, B.Last_Update_Date, B.Last_Updated_By , B.Last_Update_Login , T.PARAMETER_NAME , T.DESCRIPTION FROM qp_parameters_b B , qp_parameters_tl T WHERE B.parameter_id = T.Parameter_id AND T.Language = userenv('LANG')
View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PARAMETER_ID
, B.PARAMETER_LEVEL
, B.PARAMETER_CODE
, B.VALUE_SET_ID
, B.ADVANCED_PRICING_ONLY
, B.SEEDED_VALUE
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, T.PARAMETER_NAME
, T.DESCRIPTION
FROM QP_PARAMETERS_B B
, QP_PARAMETERS_TL T
WHERE B.PARAMETER_ID = T.PARAMETER_ID
AND T.LANGUAGE = USERENV('LANG')