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