VIEW: APPS.IEX_DUNNING_PLANS_VL

Source

View Text - Preformatted

SELECT b.rowid row_id, b.dunning_plan_id dunning_plan_id , tl.name name , tl.description description , b.start_date start_date , b.end_date end_date , b.enabled_flag enabled_flag , b.aging_bucket_id aging_bucket_id , b.score_id score_id , b.dunning_level dunning_level , b.object_version_number object_version_number , b.creation_date creation_date , b.created_by created_by , b.last_update_date last_update_date , b.last_updated_by last_updated_by , b.last_update_login last_update_login , b.program_application_id program_application_id , b.program_id program_id , b.program_update_date program_update_date , b.grace_days grace_days , b.dun_disputed_items dun_disputed_items , b.include_unused_payments_flag include_unused_payments_flag , b.dunning_type dunning_type , b.include_current include_current , b.dunning_letter_set_id dunning_letter_set_id from iex_dunning_plans_b b, iex_dunning_plans_tl tl WHERE b.dunning_plan_id = tl.dunning_plan_id and tl.language=userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.DUNNING_PLAN_ID DUNNING_PLAN_ID
, TL.NAME NAME
, TL.DESCRIPTION DESCRIPTION
, B.START_DATE START_DATE
, B.END_DATE END_DATE
, B.ENABLED_FLAG ENABLED_FLAG
, B.AGING_BUCKET_ID AGING_BUCKET_ID
, B.SCORE_ID SCORE_ID
, B.DUNNING_LEVEL DUNNING_LEVEL
, B.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, B.CREATION_DATE CREATION_DATE
, B.CREATED_BY CREATED_BY
, B.LAST_UPDATE_DATE LAST_UPDATE_DATE
, B.LAST_UPDATED_BY LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, B.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, B.PROGRAM_ID PROGRAM_ID
, B.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, B.GRACE_DAYS GRACE_DAYS
, B.DUN_DISPUTED_ITEMS DUN_DISPUTED_ITEMS
, B.INCLUDE_UNUSED_PAYMENTS_FLAG INCLUDE_UNUSED_PAYMENTS_FLAG
, B.DUNNING_TYPE DUNNING_TYPE
, B.INCLUDE_CURRENT INCLUDE_CURRENT
, B.DUNNING_LETTER_SET_ID DUNNING_LETTER_SET_ID
FROM IEX_DUNNING_PLANS_B B
, IEX_DUNNING_PLANS_TL TL
WHERE B.DUNNING_PLAN_ID = TL.DUNNING_PLAN_ID
AND TL.LANGUAGE=USERENV('LANG')