IEX_DUNNING_PLANS_VL

Details

• Schema: FUSION

• Object owner: IEX

• Object type: VIEW

Columns

Name
ROW_ID DUNNING_PLAN_ID NAME DESCRIPTION START_DATE END_DATE ENABLED_FLAG AGING_BUCKET_ID SCORE_ID DUNNING_LEVEL OBJECT_VERSION_NUMBER CREATION_DATE CREATED_BY LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN PROGRAM_APPLICATION_ID PROGRAM_ID PROGRAM_UPDATE_DATE SET_ID INCLUDE_CURRENT INCLUDE_DISPUTED INCLUDE_TRX_COPY INCLUDE_CREDIT_MEMO AGED_STAGED_FLAG

Query

SQL_Statement

SELECT b.ROWID row_id, b.DUNNING_PLAN_ID, tl.NAME, tl.DESCRIPTION, b.START_DATE, b.END_DATE, b.ENABLED_FLAG, b.AGING_BUCKET_ID, b.SCORE_ID, b.DUNNING_LEVEL, b.OBJECT_VERSION_NUMBER, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN, b.PROGRAM_APPLICATION_ID, b.PROGRAM_ID, b.PROGRAM_UPDATE_DATE, b.SET_ID, b.INCLUDE_CURRENT, b.INCLUDE_DISPUTED, b.INCLUDE_TRX_COPY, b.INCLUDE_CREDIT_MEMO, b.AGED_STAGED_FLAG 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')