VIEW: APPS.HZ_CREDIT_USAGES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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