VIEW: APPS.HZ_CREDIT_USAGE_RULES_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'