[Home] [Help]
View: 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
Name |
PROFILE_TYPE |
PROFILE_CLASS_ID |
CUST_ACCOUNT_PROFILE_ID |
CREDIT_PROFILE_ID |
PROFILE_CLASS_AMOUNT_ID |
CREDIT_PROFILE_AMT_ID |
CUST_ACCT_PROFILE_AMT_ID |
CURRENCY_CODE |
TRX_CREDIT_LIMIT |
OVERALL_CREDIT_LIMIT |