VIEW: APPS.HZ_PROFILE_AMTS_V

Source

View Text - Preformatted

SELECT 'Profile_Class' profile_type , profile_class_id , -1 cust_account_profile_id , -1 credit_profile_id , profile_class_amount_id , -1 credit_profile_amt_id , -1 cust_acct_profile_amt_id , currency_code , trx_credit_limit , overall_credit_limit FROM hz_cust_prof_class_amts UNION SELECT 'Customer' profile_type , -1 profile_class_id , cust_account_profile_id , -1 credit_profile_id , -1 profile_class_amount_id , -1 credit_profile_amt_id , cust_acct_profile_amt_id , currency_code , trx_credit_limit , overall_credit_limit FROM hz_cust_profile_amts UNION SELECT 'Operating_Unit' profile_type , -1 profile_class_id , -1 cust_account_profile_id , cp.credit_profile_id , -1 profile_class_amount_id , credit_profile_amt_id , -1 cust_acct_profile_amt_id , currency_code , trx_credit_limit , overall_credit_limit FROM hz_credit_profile_amts cpa , hz_credit_profiles cp WHERE cp.credit_profile_id=cpa.credit_profile_id AND cp.organization_id IS NOT NULL UNION SELECT 'Item_Category' profile_type , -1 profile_class_id , -1 cust_account_profile_id , cp.credit_profile_id , -1 profile_class_amount_id , credit_profile_amt_id , -1 cust_acct_profile_amt_id , currency_code , trx_credit_limit , overall_credit_limit FROM hz_credit_profile_amts cpa , hz_credit_profiles cp WHERE cp.credit_profile_id=cpa.credit_profile_id AND cp.item_category_id IS NOT NULL

View Text - HTML Formatted

SELECT 'PROFILE_CLASS' PROFILE_TYPE
, PROFILE_CLASS_ID
, -1 CUST_ACCOUNT_PROFILE_ID
, -1 CREDIT_PROFILE_ID
, PROFILE_CLASS_AMOUNT_ID
, -1 CREDIT_PROFILE_AMT_ID
, -1 CUST_ACCT_PROFILE_AMT_ID
, CURRENCY_CODE
, TRX_CREDIT_LIMIT
, OVERALL_CREDIT_LIMIT
FROM HZ_CUST_PROF_CLASS_AMTS UNION SELECT 'CUSTOMER' PROFILE_TYPE
, -1 PROFILE_CLASS_ID
, CUST_ACCOUNT_PROFILE_ID
, -1 CREDIT_PROFILE_ID
, -1 PROFILE_CLASS_AMOUNT_ID
, -1 CREDIT_PROFILE_AMT_ID
, CUST_ACCT_PROFILE_AMT_ID
, CURRENCY_CODE
, TRX_CREDIT_LIMIT
, OVERALL_CREDIT_LIMIT
FROM HZ_CUST_PROFILE_AMTS UNION SELECT 'OPERATING_UNIT' PROFILE_TYPE
, -1 PROFILE_CLASS_ID
, -1 CUST_ACCOUNT_PROFILE_ID
, CP.CREDIT_PROFILE_ID
, -1 PROFILE_CLASS_AMOUNT_ID
, CREDIT_PROFILE_AMT_ID
, -1 CUST_ACCT_PROFILE_AMT_ID
, CURRENCY_CODE
, TRX_CREDIT_LIMIT
, OVERALL_CREDIT_LIMIT
FROM HZ_CREDIT_PROFILE_AMTS CPA
, HZ_CREDIT_PROFILES CP
WHERE CP.CREDIT_PROFILE_ID=CPA.CREDIT_PROFILE_ID
AND CP.ORGANIZATION_ID IS NOT NULL UNION SELECT 'ITEM_CATEGORY' PROFILE_TYPE
, -1 PROFILE_CLASS_ID
, -1 CUST_ACCOUNT_PROFILE_ID
, CP.CREDIT_PROFILE_ID
, -1 PROFILE_CLASS_AMOUNT_ID
, CREDIT_PROFILE_AMT_ID
, -1 CUST_ACCT_PROFILE_AMT_ID
, CURRENCY_CODE
, TRX_CREDIT_LIMIT
, OVERALL_CREDIT_LIMIT
FROM HZ_CREDIT_PROFILE_AMTS CPA
, HZ_CREDIT_PROFILES CP
WHERE CP.CREDIT_PROFILE_ID=CPA.CREDIT_PROFILE_ID
AND CP.ITEM_CATEGORY_ID IS NOT NULL