Product: | AR - Receivables |
---|---|
Description: | View for profile class amounts |
Implementation/DBA Data: | APPS.AR_CUST_PROF_CLASS_AMTS |
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(+)