VIEW: APPS.CSC_ACCOUNT_BALI_V

Source

View Text - Preformatted

SELECT acct.rowid , acct.CUST_ACCOUNT_ID , acct.ORG_ID , acct.PARTY_ID , acct.ACCOUNT_NUMBER , acct.ORIG_SYSTEM_REFERENCE , acct.STATUS , ar.description , acct.CUSTOMER_TYPE , acct.CUSTOMER_CLASS_CODE , NULL , acct.TAX_CODE , NULL , NULL , acct.PAYMENT_TERM_ID , acct.TAX_ROUNDING_RULE , acct.CURRENT_BALANCE , acct.ACCOUNT_ESTABLISHED_DATE , acct.HIGH_PRIORITY_REMARKS , acct.ACCOUNT_NAME , acct.DEPOSIT_REFUND_METHOD , acct.SUSPENSION_DATE , acct.WRITE_OFF_ADJUSTMENT_AMOUNT , acct.SOURCE_CODE , acct.last_update_date , acct.last_updated_by , acct.creation_date , acct.created_by , acct.last_update_login , acct.attribute_category , acct.attribute1 , acct.attribute2 , acct.attribute3 , acct.attribute4 , acct.attribute5 , acct.attribute6 , acct.attribute7 , acct.attribute8 , acct.attribute9 , acct.attribute10 , acct.attribute11 , acct.attribute12 , acct.attribute13 , acct.attribute14 , acct.attribute15 , acct.attribute16 , acct.attribute17 , acct.attribute18 , acct.attribute19 , acct.attribute20 ,acct.object_version_number FROM HZ_CUST_ACCOUNTS acct , ar_lookups ar WHERE acct.status = ar.lookup_code AND ar.lookup_type = 'CODE_STATUS'

View Text - HTML Formatted

SELECT ACCT.ROWID
, ACCT.CUST_ACCOUNT_ID
, ACCT.ORG_ID
, ACCT.PARTY_ID
, ACCT.ACCOUNT_NUMBER
, ACCT.ORIG_SYSTEM_REFERENCE
, ACCT.STATUS
, AR.DESCRIPTION
, ACCT.CUSTOMER_TYPE
, ACCT.CUSTOMER_CLASS_CODE
, NULL
, ACCT.TAX_CODE
, NULL
, NULL
, ACCT.PAYMENT_TERM_ID
, ACCT.TAX_ROUNDING_RULE
, ACCT.CURRENT_BALANCE
, ACCT.ACCOUNT_ESTABLISHED_DATE
, ACCT.HIGH_PRIORITY_REMARKS
, ACCT.ACCOUNT_NAME
, ACCT.DEPOSIT_REFUND_METHOD
, ACCT.SUSPENSION_DATE
, ACCT.WRITE_OFF_ADJUSTMENT_AMOUNT
, ACCT.SOURCE_CODE
, ACCT.LAST_UPDATE_DATE
, ACCT.LAST_UPDATED_BY
, ACCT.CREATION_DATE
, ACCT.CREATED_BY
, ACCT.LAST_UPDATE_LOGIN
, ACCT.ATTRIBUTE_CATEGORY
, ACCT.ATTRIBUTE1
, ACCT.ATTRIBUTE2
, ACCT.ATTRIBUTE3
, ACCT.ATTRIBUTE4
, ACCT.ATTRIBUTE5
, ACCT.ATTRIBUTE6
, ACCT.ATTRIBUTE7
, ACCT.ATTRIBUTE8
, ACCT.ATTRIBUTE9
, ACCT.ATTRIBUTE10
, ACCT.ATTRIBUTE11
, ACCT.ATTRIBUTE12
, ACCT.ATTRIBUTE13
, ACCT.ATTRIBUTE14
, ACCT.ATTRIBUTE15
, ACCT.ATTRIBUTE16
, ACCT.ATTRIBUTE17
, ACCT.ATTRIBUTE18
, ACCT.ATTRIBUTE19
, ACCT.ATTRIBUTE20
, ACCT.OBJECT_VERSION_NUMBER
FROM HZ_CUST_ACCOUNTS ACCT
, AR_LOOKUPS AR
WHERE ACCT.STATUS = AR.LOOKUP_CODE
AND AR.LOOKUP_TYPE = 'CODE_STATUS'