CN_PAYMENT_PLANS_ALL_VL

Details

• Schema: FUSION

• Object owner: CN

• Object type: VIEW

Columns

Name

PAYMENT_PLAN_NAME DESCRIPTION ORG_ID PAYMENT_PLAN_ID MINIMUM_AMOUNT MAXIMUM_AMOUNT MIN_RECOVER_FLAG PAY_EXCESS_LATER_FLAG MAX_RECOVERY_AMOUNT CREDIT_TYPE_ID PAY_INTERVAL_TYPE_ID START_DATE END_DATE ATTRIBUTE_CATEGORY ATTRIBUTE1 ATTRIBUTE2 ATTRIBUTE3 ATTRIBUTE4 ATTRIBUTE5 ATTRIBUTE6 ATTRIBUTE7 ATTRIBUTE8 ATTRIBUTE9 ATTRIBUTE10 ATTRIBUTE11 ATTRIBUTE12 ATTRIBUTE13 ATTRIBUTE14 ATTRIBUTE15 CREATED_BY CREATION_DATE LAST_UPDATE_LOGIN DRAW_PERCENT_AMOUNT DRAW_EXPRESSION_ID RECOVER_EXPRESSION_ID DRAW_END LAST_UPDATE_DATE RECOVER_PERCENT_AMOUNT RECOVERY_END_INTERVAL_ID RECOVERY_START_INTERVAL_ID LAST_UPDATED_BY PAYMENT_PLAN_CATEGORY OBJECT_VERSION_NUMBER RECOVER_INTERVAL_TYPE_ID DELAY_RECOVERY_FLAG

Query

SQL_Statement

SELECT T.PAYMENT_PLAN_NAME, T.DESCRIPTION, B.ORG_ID, B.PAYMENT_PLAN_ID, B.MINIMUM_AMOUNT, B.MAXIMUM_AMOUNT, B.MIN_RECOVER_FLAG, B.PAY_EXCESS_LATER_FLAG, B.MAX_RECOVERY_AMOUNT, B.CREDIT_TYPE_ID, B.PAY_INTERVAL_TYPE_ID, B.START_DATE, B.END_DATE, B.ATTRIBUTE_CATEGORY, B.ATTRIBUTE1, B.ATTRIBUTE2, B.ATTRIBUTE3, B.ATTRIBUTE4, B.ATTRIBUTE5, B.ATTRIBUTE6 , B.ATTRIBUTE7 , B.ATTRIBUTE8 , B.ATTRIBUTE9 , B.ATTRIBUTE10 , B.ATTRIBUTE11 , B.ATTRIBUTE12 , B.ATTRIBUTE13 , B.ATTRIBUTE14 , B.ATTRIBUTE15 , B.CREATED_BY , B.CREATION_DATE, B.LAST_UPDATE_LOGIN , B.DRAW_PERCENT_AMOUNT , B.DRAW_EXPRESSION_ID , B.RECOVER_EXPRESSION_ID , B.DRAW_END, B.LAST_UPDATE_DATE , B.RECOVER_PERCENT_AMOUNT , B.RECOVERY_END_INTERVAL_ID , B.RECOVERY_START_INTERVAL_ID , B.LAST_UPDATED_BY , B.PAYMENT_PLAN_CATEGORY , B.OBJECT_VERSION_NUMBER, B.RECOVER_INTERVAL_TYPE_ID , B.DELAY_RECOVERY_FLAG FROM CN_PAYMENT_PLANS_ALL_B B, CN_PAYMENT_PLANS_ALL_TL T WHERE B.PAYMENT_PLAN_ID = T.PAYMENT_PLAN_ID AND T.LANGUAGE = USERENV('LANG') AND B.ORG_ID = T.ORG_ID