Product: | AST - TeleSales |
---|---|
Description: | AST_CUST_ACCT_OVERVIEW_V retrieves an overview of the customer account. |
Implementation/DBA Data: | APPS.AST_CUST_ACCT_OVERVIEW_V |
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.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.CREATED_BY_MODULE
, CUST_ACCT.APPLICATION_ID
, CUST_ACCT.OBJECT_VERSION_NUMBER
, 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'