VIEW: APPS.IEX_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 , cust_acct.account_number account_number , cust_acct.orig_system_reference orig_system_reference , cust_acct.status status , arpt_sql_func_util.get_lookup_meaning('CODE_STATUS',cust_acct.status) 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 , NULL amount_overdue , NULL net_balance , NULL currency_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

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
, CUST_ACCT.ACCOUNT_NUMBER ACCOUNT_NUMBER
, CUST_ACCT.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, CUST_ACCT.STATUS STATUS
, ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING('CODE_STATUS'
, CUST_ACCT.STATUS) 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
, NULL AMOUNT_OVERDUE
, NULL NET_BALANCE
, NULL CURRENCY_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