Query to get the Customer Profile Class setup data in 11i

select  a.customer_profile_class_id,a.PROFILE_CLASS_NAME,a.PROFILE_CLASS_DESCRIPTION,a.status,a.collector_name,a.STANDARD_TERMS_NAME Payment_terms,
a.override_terms,a.PAYMENT_GRACE_DAYS,a.GROUPING_RULE_NAME,a.DUNNING_LETTERS,a.DUNNING_LETTER_SET_NAME,a.TOLERANCE,a.CREDIT_CHECKING,
b.CURRENCY_CODE,b.OVERALL_CREDIT_LIMIT Credit_limit,b.TRX_CREDIT_LIMIT Order_limit
from AR_CUSTOMER_PROFILE_CLASSES_V a,
AR_CUST_PROF_CLASS_AMOUNTS b where a.customer_profile_class_id=b.customer_profile_class_id