Product: | AR - Receivables |
---|---|
Description: | |
Implementation/DBA Data: | APPS.HZ_CREDIT_USAGE_RULES_V |
SELECT CUR.ROWID
, CUR.CREDIT_USAGE_RULE_ID
, CUR.USAGE_TYPE
, CUR.USER_CODE
, CUR.EXCLUDE_FLAG
, CUR.INCLUDE_ALL_FLAG
, CUR.CREDIT_USAGE_RULE_SET_ID
, CUR.CREATION_DATE
, CUR.CREATED_BY
, CUR.LAST_UPDATE_DATE
, CUR.LAST_UPDATED_BY
, CUR.LAST_UPDATE_LOGIN
, CUR.PROGRAM_APPLICATION_ID
, CUR.PROGRAM_ID
, CUR.PROGRAM_UPDATE_DATE
, CUR.REQUEST_ID
, CUR.ATTRIBUTE_CATEGORY
, CUR.ATTRIBUTE1
, CUR.ATTRIBUTE2
, CUR.ATTRIBUTE3
, CUR.ATTRIBUTE4
, CUR.ATTRIBUTE5
, CUR.ATTRIBUTE6
, CUR.ATTRIBUTE7
, CUR.ATTRIBUTE8
, CUR.ATTRIBUTE9
, CUR.ATTRIBUTE10
, CUR.ATTRIBUTE11
, CUR.ATTRIBUTE12
, CUR.ATTRIBUTE13
, CUR.ATTRIBUTE14
, CUR.ATTRIBUTE15
, AL.MEANING
FROM HZ_CREDIT_USAGE_RULES CUR
, AR_LOOKUPS AL
WHERE CUR.USAGE_TYPE=AL.LOOKUP_CODE
AND AL.LOOKUP_TYPE='AR_CC_CREDIT_USAGE_TYPE'