VIEW: APPS.IEX_PAYING_CUST_ACCT_BALI_V

Source

View Text - Preformatted

SELECT cust_acct.rowid ROW_ID, cust_acct.CUST_ACCOUNT_ID CUST_ACCOUNT_ID, cust_acct.ORG_ID ORG_ID, cust_acct.PARTY_ID PARTY_ID, party.PARTY_NAME PARTY_NAME, cust_acct.ACCOUNT_NUMBER ACCOUNT_NUMBER, cust_acct.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE, cust_acct.STATUS STATUS, status_lookup.description ACCOUNT_STATUS_DESCRIPTION, cust_acct.CUSTOMER_TYPE CUSTOMER_TYPE, cust_acct.CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE, NULL CATEGORY_CODE, cust_acct.SUBCATEGORY_CODE SUBCATEGORY_CODE, cust_acct.TAX_CODE TAX_CODE, NULL THIRD_PARTY_FLAG, NULL COMPETITOR_FLAG, cust_acct.PAYMENT_TERM_ID PAYMENT_TERM_ID, cust_acct.TAX_ROUNDING_RULE TAX_ROUNDING_RULE, cust_acct.CURRENT_BALANCE CURRENT_BALANCE, cust_acct.HIGH_PRIORITY_INDICATOR HIGH_PRIORITY_INDICATOR, cust_acct.ACCOUNT_ESTABLISHED_DATE ACCOUNT_ESTABLISHED_DATE, cust_acct.ACCOUNT_TERMINATION_DATE ACCOUNT_TERMINATION_DATE, cust_acct.ACCOUNT_ACTIVATION_DATE ACCOUNT_ACTIVATION_DATE, cust_acct.HIGH_PRIORITY_REMARKS HIGH_PRIORITY_REMARKS, cust_acct.ACCOUNT_NAME ACCOUNT_NAME, cust_acct.DEPOSIT_REFUND_METHOD DEPOSIT_REFUND_METHOD, cust_acct.SUSPENSION_DATE SUSPENSION_DATE, cust_acct.WRITE_OFF_ADJUSTMENT_AMOUNT WRITE_OFF_ADJUSTMENT_AMOUNT, cust_acct.WRITE_OFF_PAYMENT_AMOUNT WRITE_OFF_PAYMENT_AMOUNT, cust_acct.WRITE_OFF_AMOUNT WRITE_OFF_AMOUNT, cust_acct.SOURCE_CODE SOURCE_CODE, cust_acct.last_update_date LAST_UPDATE_DATE, cust_acct.last_updated_by LAST_UPDATED_BY, cust_acct.creation_date CREATION_DATE, cust_acct.created_by CREATED_BY, cust_acct.last_update_login LAST_UPDATE_LOGIN, cust_acct.attribute_category ATTRIBUTE_CATEGORY, cust_acct.attribute1 ATTRIBUTE1, cust_acct.attribute2 ATTRIBUTE2, cust_acct.attribute3 ATTRIBUTE3, cust_acct.attribute4 ATTRIBUTE4, cust_acct.attribute5 ATTRIBUTE5, cust_acct.attribute6 ATTRIBUTE6, cust_acct.attribute7 ATTRIBUTE7, cust_acct.attribute8 ATTRIBUTE8, cust_acct.attribute9 ATTRIBUTE9, cust_acct.attribute10 ATTRIBUTE10, cust_acct.attribute11 ATTRIBUTE11, cust_acct.attribute12 ATTRIBUTE12, cust_acct.attribute13 ATTRIBUTE13, cust_acct.attribute14 ATTRIBUTE14, cust_acct.attribute15 ATTRIBUTE15, cust_acct.attribute16 ATTRIBUTE16, cust_acct.attribute17 ATTRIBUTE17, cust_acct.attribute18 ATTRIBUTE18, cust_acct.attribute19 ATTRIBUTE19, cust_acct.attribute20 ATTRIBUTE20 FROM HZ_CUST_ACCOUNTS cust_acct , ar_lookups status_lookup , hz_parties party WHERE cust_acct.status = status_lookup.lookup_code AND status_lookup.lookup_type = 'CODE_STATUS' AND cust_acct.party_id = party.party_id

View Text - HTML Formatted

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