View: HZ_PROFILE_AMTS_V

Product:	AR - Receivables
Description:
Implementation/DBA Data:	APPS.HZ_PROFILE_AMTS_V

View Text

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

Columns