[Home] [Help]
View: BIS_BUSINESS_PLANS_VL
View Text
SELECT PLAN.ROWID ROW_ID
, PLAN.PLAN_ID
, PLAN.SHORT_NAME
, PLAN.VERSION_NO
, PLAN.CURRENT_PLAN_FLAG
, PLAN.CREATION_DATE
, PLAN.CREATED_BY
, PLAN.LAST_UPDATE_DATE
, PLAN.LAST_UPDATED_BY
, PLAN.LAST_UPDATE_LOGIN
, PLAN_TL.NAME
, PLAN_TL.DESCRIPTION
FROM BIS_BUSINESS_PLANS PLAN
, BIS_BUSINESS_PLANS_TL PLAN_TL
WHERE PLAN.PLAN_ID = PLAN_TL.PLAN_ID
AND PLAN_TL.LANGUAGE = USERENV('LANG')
Columns
Name |
ROW_ID |
PLAN_ID |
SHORT_NAME |
VERSION_NO |
CURRENT_PLAN_FLAG |
CREATION_DATE |
CREATED_BY |
LAST_UPDATE_DATE |
LAST_UPDATED_BY |
LAST_UPDATE_LOGIN |
NAME |
DESCRIPTION |