VIEW: APPS.QPR_PRICE_PLANS_VL

Source

View Text - Preformatted

SELECT b.PRICE_PLAN_ID, b.INSTANCE_ID, tl.NAME, tl.description, b.AW_TYPE_CODE, b.AW_CODE, b.AW_STATUS_CODE, b.AW_XML, b.AW_CREATED_FLAG, b.TEMPLATE_FLAG, b.START_DATE, b.END_DATE, b.BASE_UOM_CODE, b.CURRENCY_CODE, b.USE_FOR_DEAL_FLAG, b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.last_update_login from qpr_price_plans_b b, qpr_price_plans_tl tl WHERE b.price_plan_id = tl.price_plan_id and tl.language = userenv('LANG')

View Text - HTML Formatted

SELECT B.PRICE_PLAN_ID
, B.INSTANCE_ID
, TL.NAME
, TL.DESCRIPTION
, B.AW_TYPE_CODE
, B.AW_CODE
, B.AW_STATUS_CODE
, B.AW_XML
, B.AW_CREATED_FLAG
, B.TEMPLATE_FLAG
, B.START_DATE
, B.END_DATE
, B.BASE_UOM_CODE
, B.CURRENCY_CODE
, B.USE_FOR_DEAL_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM QPR_PRICE_PLANS_B B
, QPR_PRICE_PLANS_TL TL
WHERE B.PRICE_PLAN_ID = TL.PRICE_PLAN_ID
AND TL.LANGUAGE = USERENV('LANG')