VIEW: APPS.AR_CUST_PROF_CLASS_AMTS

Source

View Text - Preformatted

SELECT a.PROFILE_CLASS_AMOUNT_ID PROFILE_CLASS_AMOUNT_ID, a.PROFILE_CLASS_ID PROFILE_CLASS_ID, a.CURRENCY_CODE CURRENCY_CODE, a.OVERALL_CREDIT_LIMIT OVERALL_CREDIT_LIMIT, a.AUTO_REC_MIN_RECEIPT_AMOUNT AUTO_REC_MIN_RECEIPT_AMOUNT, a.TRX_CREDIT_LIMIT TRX_CREDIT_LIMIT, a.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE, gdc.user_conversion_type EXCHANGE_RATE_TYPE_M, a.MIN_FC_BALANCE_OVERDUE_TYPE MIN_FC_BALANCE_OVERDUE_TYPE, ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_AMOUNT_PERCENT', a.MIN_FC_BALANCE_OVERDUE_TYPE) MIN_FC_BALANCE_OVERDUE_TYPE_M, a.MIN_FC_BALANCE_PERCENT MIN_FC_BALANCE_PERCENT, a.MIN_FC_BALANCE_AMOUNT MIN_FC_BALANCE_AMOUNT, DECODE(a.MIN_FC_BALANCE_OVERDUE_TYPE,'AMOUNT', a.MIN_FC_BALANCE_AMOUNT,a.MIN_FC_BALANCE_PERCENT) MIN_FC_BALANCE_VALUE, a.MIN_FC_INVOICE_OVERDUE_TYPE MIN_FC_INVOICE_OVERDUE_TYPE, ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_AMOUNT_PERCENT',a.MIN_FC_INVOICE_OVERDUE_TYPE) MIN_FC_INVOICE_OVERDUE_TYPE_M, a.MIN_FC_INVOICE_PERCENT MIN_FC_INVOICE_PERCENT, a.MIN_FC_INVOICE_AMOUNT MIN_FC_INVOICE_AMOUNT, DECODE(a.MIN_FC_INVOICE_OVERDUE_TYPE,'AMOUNT', a.MIN_FC_INVOICE_AMOUNT,a.MIN_FC_INVOICE_PERCENT) MIN_FC_INVOICE_VALUE, a.MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE, a.MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE, a.INTEREST_TYPE INTEREST_TYPE, ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_INTEREST_PENALTY_TYPE',a.INTEREST_TYPE) INTEREST_TYPE_M, a.INTEREST_RATE INTEREST_RATE, a.INTEREST_FIXED_AMOUNT INTEREST_FIXED_AMOUNT, DECODE(a.INTEREST_TYPE,'FIXED_AMOUNT',a.INTEREST_FIXED_AMOUNT, 'FIXED_RATE' ,a.INTEREST_RATE,NULL) INTEREST_VALUE, DECODE(a.INTEREST_TYPE,'CHARGES_SCHEDULE', a.INTEREST_SCHEDULE_ID,'CHARGE_PER_TIER',a.INTEREST_SCHEDULE_ID,NULL) INTEREST_SCHEDULE_ID, DECODE(a.INTEREST_TYPE,'CHARGES_SCHEDULE', I.SCHEDULE_NAME,'CHARGE_PER_TIER',I.SCHEDULE_NAME,NULL) INTEREST_SCHEDULE_NAME, a.PENALTY_TYPE PENALTY_TYPE, ARPT_SQL_FUNC_UTIL.get_lookup_meaning ('AR_INTEREST_PENALTY_TYPE',a.PENALTY_TYPE) PENALTY_TYPE_M, a.PENALTY_RATE PENALTY_RATE, a.PENALTY_FIXED_AMOUNT PENALTY_FIXED_AMOUNT, DECODE(a.PENALTY_TYPE,'FIXED_AMOUNT',a.PENALTY_FIXED_AMOUNT, 'FIXED_RATE' ,a.PENALTY_RATE,NULL) PENALTY_VALUE, DECODE(a.PENALTY_TYPE,'CHARGES_SCHEDULE', a.PENALTY_SCHEDULE_ID,'CHARGE_PER_TIER', a.PENALTY_SCHEDULE_ID,NULL) PENALTY_SCHEDULE_ID, DECODE(a.PENALTY_TYPE,'CHARGES_SCHEDULE', P.SCHEDULE_NAME,'CHARGE_PER_TIER',P.SCHEDULE_NAME,NULL) PENALTY_SCHEDULE_NAME, a.ATTRIBUTE_CATEGORY , a.ATTRIBUTE1 , a.ATTRIBUTE2 , a.ATTRIBUTE3 , a.ATTRIBUTE4 , a.ATTRIBUTE5 , a.ATTRIBUTE6 , a.ATTRIBUTE7 , a.ATTRIBUTE8 , a.ATTRIBUTE9 , a.ATTRIBUTE10 , a.ATTRIBUTE11 , a.ATTRIBUTE12 , a.ATTRIBUTE13 , a.ATTRIBUTE14 , a.ATTRIBUTE15 , a.JGZZ_ATTRIBUTE_CATEGORY , a.JGZZ_ATTRIBUTE1 , a.JGZZ_ATTRIBUTE2 , a.JGZZ_ATTRIBUTE3 , a.JGZZ_ATTRIBUTE4 , a.JGZZ_ATTRIBUTE5 , a.JGZZ_ATTRIBUTE6 , a.JGZZ_ATTRIBUTE7 , a.JGZZ_ATTRIBUTE8 , a.JGZZ_ATTRIBUTE9 , a.JGZZ_ATTRIBUTE10 , a.JGZZ_ATTRIBUTE11 , a.JGZZ_ATTRIBUTE12 , a.JGZZ_ATTRIBUTE13 , a.JGZZ_ATTRIBUTE14 , a.JGZZ_ATTRIBUTE15 , a.GLOBAL_ATTRIBUTE_CATEGORY , a.GLOBAL_ATTRIBUTE1 , a.GLOBAL_ATTRIBUTE2 , a.GLOBAL_ATTRIBUTE3 , a.GLOBAL_ATTRIBUTE4 , a.GLOBAL_ATTRIBUTE5 , a.GLOBAL_ATTRIBUTE6 , a.GLOBAL_ATTRIBUTE7 , a.GLOBAL_ATTRIBUTE8 , a.GLOBAL_ATTRIBUTE9 , a.GLOBAL_ATTRIBUTE10 , a.GLOBAL_ATTRIBUTE11 , a.GLOBAL_ATTRIBUTE12 , a.GLOBAL_ATTRIBUTE13 , a.GLOBAL_ATTRIBUTE14 , a.GLOBAL_ATTRIBUTE15 , a.GLOBAL_ATTRIBUTE16 , a.GLOBAL_ATTRIBUTE17 , a.GLOBAL_ATTRIBUTE18 , a.GLOBAL_ATTRIBUTE19 , a.GLOBAL_ATTRIBUTE20 , a.MIN_DUNNING_AMOUNT , a.MIN_STATEMENT_AMOUNT , a.MIN_DUNNING_INVOICE_AMOUNT , a.EXPIRATION_DATE , a.LAST_UPDATED_BY , a.LAST_UPDATE_DATE , a.CREATED_BY , a.CREATION_DATE , a.REQUEST_ID , a.PROGRAM_APPLICATION_ID , a.PROGRAM_ID , a.PROGRAM_UPDATE_DATE , a.WH_UPDATE_DATE , a.LAST_UPDATE_LOGIN FROM hz_cust_prof_class_amts a, ar_charge_schedules i, ar_charge_schedules p, gl_daily_conversion_types gdc WHERE a.INTEREST_SCHEDULE_ID = i.SCHEDULE_ID(+) AND a.PENALTY_SCHEDULE_ID = p.SCHEDULE_ID(+) AND a.EXCHANGE_RATE_TYPE = gdc.conversion_type(+)

View Text - HTML Formatted

SELECT A.PROFILE_CLASS_AMOUNT_ID PROFILE_CLASS_AMOUNT_ID
, A.PROFILE_CLASS_ID PROFILE_CLASS_ID
, A.CURRENCY_CODE CURRENCY_CODE
, A.OVERALL_CREDIT_LIMIT OVERALL_CREDIT_LIMIT
, A.AUTO_REC_MIN_RECEIPT_AMOUNT AUTO_REC_MIN_RECEIPT_AMOUNT
, A.TRX_CREDIT_LIMIT TRX_CREDIT_LIMIT
, A.EXCHANGE_RATE_TYPE EXCHANGE_RATE_TYPE
, GDC.USER_CONVERSION_TYPE EXCHANGE_RATE_TYPE_M
, A.MIN_FC_BALANCE_OVERDUE_TYPE MIN_FC_BALANCE_OVERDUE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_AMOUNT_PERCENT'
, A.MIN_FC_BALANCE_OVERDUE_TYPE) MIN_FC_BALANCE_OVERDUE_TYPE_M
, A.MIN_FC_BALANCE_PERCENT MIN_FC_BALANCE_PERCENT
, A.MIN_FC_BALANCE_AMOUNT MIN_FC_BALANCE_AMOUNT
, DECODE(A.MIN_FC_BALANCE_OVERDUE_TYPE
, 'AMOUNT'
, A.MIN_FC_BALANCE_AMOUNT
, A.MIN_FC_BALANCE_PERCENT) MIN_FC_BALANCE_VALUE
, A.MIN_FC_INVOICE_OVERDUE_TYPE MIN_FC_INVOICE_OVERDUE_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_AMOUNT_PERCENT'
, A.MIN_FC_INVOICE_OVERDUE_TYPE) MIN_FC_INVOICE_OVERDUE_TYPE_M
, A.MIN_FC_INVOICE_PERCENT MIN_FC_INVOICE_PERCENT
, A.MIN_FC_INVOICE_AMOUNT MIN_FC_INVOICE_AMOUNT
, DECODE(A.MIN_FC_INVOICE_OVERDUE_TYPE
, 'AMOUNT'
, A.MIN_FC_INVOICE_AMOUNT
, A.MIN_FC_INVOICE_PERCENT) MIN_FC_INVOICE_VALUE
, A.MAX_INTEREST_CHARGE MAX_INTEREST_CHARGE
, A.MIN_INTEREST_CHARGE MIN_INTEREST_CHARGE
, A.INTEREST_TYPE INTEREST_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_INTEREST_PENALTY_TYPE'
, A.INTEREST_TYPE) INTEREST_TYPE_M
, A.INTEREST_RATE INTEREST_RATE
, A.INTEREST_FIXED_AMOUNT INTEREST_FIXED_AMOUNT
, DECODE(A.INTEREST_TYPE
, 'FIXED_AMOUNT'
, A.INTEREST_FIXED_AMOUNT
, 'FIXED_RATE'
, A.INTEREST_RATE
, NULL) INTEREST_VALUE
, DECODE(A.INTEREST_TYPE
, 'CHARGES_SCHEDULE'
, A.INTEREST_SCHEDULE_ID
, 'CHARGE_PER_TIER'
, A.INTEREST_SCHEDULE_ID
, NULL) INTEREST_SCHEDULE_ID
, DECODE(A.INTEREST_TYPE
, 'CHARGES_SCHEDULE'
, I.SCHEDULE_NAME
, 'CHARGE_PER_TIER'
, I.SCHEDULE_NAME
, NULL) INTEREST_SCHEDULE_NAME
, A.PENALTY_TYPE PENALTY_TYPE
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_INTEREST_PENALTY_TYPE'
, A.PENALTY_TYPE) PENALTY_TYPE_M
, A.PENALTY_RATE PENALTY_RATE
, A.PENALTY_FIXED_AMOUNT PENALTY_FIXED_AMOUNT
, DECODE(A.PENALTY_TYPE
, 'FIXED_AMOUNT'
, A.PENALTY_FIXED_AMOUNT
, 'FIXED_RATE'
, A.PENALTY_RATE
, NULL) PENALTY_VALUE
, DECODE(A.PENALTY_TYPE
, 'CHARGES_SCHEDULE'
, A.PENALTY_SCHEDULE_ID
, 'CHARGE_PER_TIER'
, A.PENALTY_SCHEDULE_ID
, NULL) PENALTY_SCHEDULE_ID
, DECODE(A.PENALTY_TYPE
, 'CHARGES_SCHEDULE'
, P.SCHEDULE_NAME
, 'CHARGE_PER_TIER'
, P.SCHEDULE_NAME
, NULL) PENALTY_SCHEDULE_NAME
, A.ATTRIBUTE_CATEGORY
, A.ATTRIBUTE1
, A.ATTRIBUTE2
, A.ATTRIBUTE3
, A.ATTRIBUTE4
, A.ATTRIBUTE5
, A.ATTRIBUTE6
, A.ATTRIBUTE7
, A.ATTRIBUTE8
, A.ATTRIBUTE9
, A.ATTRIBUTE10
, A.ATTRIBUTE11
, A.ATTRIBUTE12
, A.ATTRIBUTE13
, A.ATTRIBUTE14
, A.ATTRIBUTE15
, A.JGZZ_ATTRIBUTE_CATEGORY
, A.JGZZ_ATTRIBUTE1
, A.JGZZ_ATTRIBUTE2
, A.JGZZ_ATTRIBUTE3
, A.JGZZ_ATTRIBUTE4
, A.JGZZ_ATTRIBUTE5
, A.JGZZ_ATTRIBUTE6
, A.JGZZ_ATTRIBUTE7
, A.JGZZ_ATTRIBUTE8
, A.JGZZ_ATTRIBUTE9
, A.JGZZ_ATTRIBUTE10
, A.JGZZ_ATTRIBUTE11
, A.JGZZ_ATTRIBUTE12
, A.JGZZ_ATTRIBUTE13
, A.JGZZ_ATTRIBUTE14
, A.JGZZ_ATTRIBUTE15
, A.GLOBAL_ATTRIBUTE_CATEGORY
, A.GLOBAL_ATTRIBUTE1
, A.GLOBAL_ATTRIBUTE2
, A.GLOBAL_ATTRIBUTE3
, A.GLOBAL_ATTRIBUTE4
, A.GLOBAL_ATTRIBUTE5
, A.GLOBAL_ATTRIBUTE6
, A.GLOBAL_ATTRIBUTE7
, A.GLOBAL_ATTRIBUTE8
, A.GLOBAL_ATTRIBUTE9
, A.GLOBAL_ATTRIBUTE10
, A.GLOBAL_ATTRIBUTE11
, A.GLOBAL_ATTRIBUTE12
, A.GLOBAL_ATTRIBUTE13
, A.GLOBAL_ATTRIBUTE14
, A.GLOBAL_ATTRIBUTE15
, A.GLOBAL_ATTRIBUTE16
, A.GLOBAL_ATTRIBUTE17
, A.GLOBAL_ATTRIBUTE18
, A.GLOBAL_ATTRIBUTE19
, A.GLOBAL_ATTRIBUTE20
, A.MIN_DUNNING_AMOUNT
, A.MIN_STATEMENT_AMOUNT
, A.MIN_DUNNING_INVOICE_AMOUNT
, A.EXPIRATION_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_DATE
, A.CREATED_BY
, A.CREATION_DATE
, A.REQUEST_ID
, A.PROGRAM_APPLICATION_ID
, A.PROGRAM_ID
, A.PROGRAM_UPDATE_DATE
, A.WH_UPDATE_DATE
, A.LAST_UPDATE_LOGIN
FROM HZ_CUST_PROF_CLASS_AMTS A
, AR_CHARGE_SCHEDULES I
, AR_CHARGE_SCHEDULES P
, GL_DAILY_CONVERSION_TYPES GDC
WHERE A.INTEREST_SCHEDULE_ID = I.SCHEDULE_ID(+)
AND A.PENALTY_SCHEDULE_ID = P.SCHEDULE_ID(+)
AND A.EXCHANGE_RATE_TYPE = GDC.CONVERSION_TYPE(+)