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, gl_ledgers_public_v gl, ar_system_parameters arsys WHERE arsys.set_of_books_id = gl.ledger_id AND 1 = iex_currency_pvt.get_currency_count UNION ALL 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 WHERE 1 <> iex_currency_pvt.get_currency_count

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
, GL_LEDGERS_PUBLIC_V GL
, AR_SYSTEM_PARAMETERS ARSYS
WHERE ARSYS.SET_OF_BOOKS_ID = GL.LEDGER_ID
AND 1 = IEX_CURRENCY_PVT.GET_CURRENCY_COUNT UNION ALL 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
WHERE 1 <> IEX_CURRENCY_PVT.GET_CURRENCY_COUNT