Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_CREDIT_USAGES_V |
SELECT CU.ROWID
, CU.CREDIT_USAGE_ID
, NVL(CU.CREDIT_PROFILE_AMT_ID
, -1)
, NVL(CU.CUST_ACCT_PROFILE_AMT_ID
, -1)
, NVL(CU.PROFILE_CLASS_AMOUNT_ID
, -1)
, CU.CREDIT_USAGE_RULE_SET_ID
, CU.CREATION_DATE
, CU.CREATED_BY
, CU.LAST_UPDATE_DATE
, CU.LAST_UPDATED_BY
, CU.LAST_UPDATE_LOGIN
, CU.PROGRAM_APPLICATION_ID
, CU.PROGRAM_ID
, CU.PROGRAM_UPDATE_DATE
, CU.REQUEST_ID
, CU.ATTRIBUTE_CATEGORY
, CU.ATTRIBUTE1
, CU.ATTRIBUTE2
, CU.ATTRIBUTE3
, CU.ATTRIBUTE4
, CU.ATTRIBUTE5
, CU.ATTRIBUTE6
, CU.ATTRIBUTE7
, CU.ATTRIBUTE8
, CU.ATTRIBUTE9
, CU.ATTRIBUTE10
, CU.ATTRIBUTE11
, CU.ATTRIBUTE12
, CU.ATTRIBUTE13
, CU.ATTRIBUTE14
, CU.ATTRIBUTE15
, CURS.NAME
FROM HZ_CREDIT_USAGES CU
, HZ_CREDIT_USAGE_RULE_SETS_VL CURS
WHERE CU.CREDIT_USAGE_RULE_SET_ID=CURS.CREDIT_USAGE_RULE_SET_ID