VIEW: APPS.AST_CUST_ACCT_BALI_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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