VIEW: APPS.HZ_WSRVC_PERSON_ACCOUNT_V

Source

View Text - Preformatted

SELECT cust.cust_account_id cust_cust_account_id, cust.account_number cust_account_number, cust.last_update_date cust_last_update_date, cust.last_updated_by cust_last_updated_by, cust.creation_date cust_creation_date, cust.created_by cust_created_by, cust.last_update_login cust_last_update_login, cust.attribute_category cust_attribute_category, cust.attribute1 cust_attribute1, cust.attribute2 cust_attribute2, cust.attribute3 cust_attribute3, cust.attribute4 cust_attribute4, cust.attribute5 cust_attribute5, cust.attribute6 cust_attribute6, cust.attribute7 cust_attribute7, cust.attribute8 cust_attribute8, cust.attribute9 cust_attribute9, cust.attribute10 cust_attribute10, cust.attribute11 cust_attribute11, cust.attribute12 cust_attribute12, cust.attribute13 cust_attribute13, cust.attribute14 cust_attribute14, cust.attribute15 cust_attribute15, cust.attribute16 cust_attribute16, cust.attribute17 cust_attribute17, cust.attribute18 cust_attribute18, cust.attribute19 cust_attribute19, cust.attribute20 cust_attribute20, cust.global_attribute_category cust_global_attribute_category, cust.global_attribute1 cust_global_attribute1, cust.global_attribute2 cust_global_attribute2, cust.global_attribute3 cust_global_attribute3, cust.global_attribute4 cust_global_attribute4, cust.global_attribute5 cust_global_attribute5, cust.global_attribute6 cust_global_attribute6, cust.global_attribute7 cust_global_attribute7, cust.global_attribute8 cust_global_attribute8, cust.global_attribute9 cust_global_attribute9, cust.global_attribute10 cust_global_attribute10, cust.global_attribute11 cust_global_attribute11, cust.global_attribute12 cust_global_attribute12, cust.global_attribute13 cust_global_attribute13, cust.global_attribute14 cust_global_attribute14, cust.global_attribute15 cust_global_attribute15, cust.global_attribute16 cust_global_attribute16, cust.global_attribute17 cust_global_attribute17, cust.global_attribute18 cust_global_attribute18, cust.global_attribute19 cust_global_attribute19, cust.global_attribute20 cust_global_attribute20, cust.orig_system_reference cust_orig_system_reference, 'CUST_MOSR' cust_orig_system, cust.status cust_status, cust.customer_type cust_customer_type, cust.customer_class_code cust_customer_class_code, cust.primary_salesrep_id cust_primary_salesrep_id, cust.sales_channel_code cust_sales_channel_code, cust.order_type_id cust_order_type_id, cust.price_list_id cust_price_list_id, cust.tax_code cust_tax_code, cust.fob_point cust_fob_point, cust.freight_term cust_freight_term, cust.ship_via cust_ship_via, cust.warehouse_id cust_warehouse_id, cust.tax_header_level_flag cust_tax_header_level_flag, cust.tax_rounding_rule cust_tax_rounding_rule, cust.coterminate_day_month cust_coterminate_day_month, cust.primary_specialist_id cust_primary_specialist_id, cust.secondary_specialist_id cust_secondary_specialist_id, cust.account_liable_flag cust_account_liable_flag, cust.current_balance cust_current_balance, cust.account_established_date cust_account_established_date, cust.account_termination_date cust_account_termination_date, cust.account_activation_date cust_account_activation_date, cust.department cust_department, cust.held_bill_expiration_date cust_held_bill_expiration_date, cust.hold_bill_flag cust_hold_bill_flag, cust.realtime_rate_flag cust_realtime_rate_flag, cust.acct_life_cycle_status cust_acct_life_cycle_status, cust.account_name cust_account_name, cust.deposit_refund_method cust_deposit_refund_method, cust.dormant_account_flag cust_dormant_account_flag, cust.npa_number cust_npa_number, cust.suspension_date cust_suspension_date, cust.source_code cust_source_code, cust.comments cust_comments, cust.dates_negative_tolerance cust_dates_negative_tolerance, cust.dates_positive_tolerance cust_dates_positive_tolerance, cust.date_type_preference cust_date_type_preference, cust.over_shipment_tolerance cust_over_shipment_tolerance, cust.under_shipment_tolerance cust_under_shipment_tolerance, cust.over_return_tolerance cust_over_return_tolerance, cust.under_return_tolerance cust_under_return_tolerance, cust.item_cross_ref_pref cust_item_cross_ref_pref, cust.ship_sets_include_lines_flag ship_sets_include_lines_flag, cust.arrivalsets_include_lines_flag arrivalsets_include_lines_flag, cust.sched_date_push_flag cust_sched_date_push_flag, cust.invoice_quantity_rule cust_invoice_quantity_rule, cust.status_update_date cust_status_update_date, cust.autopay_flag cust_autopay_flag, cust.notify_flag cust_notify_flag, cust.last_batch_id cust_last_batch_id, cust.selling_party_id cust_selling_party_id, cust.created_by_module cust_created_by_module, cust.application_id cust_application_id, cust.object_version_number cust_object_version_number, prof.cust_account_profile_id prof_cust_account_profile_id, prof.last_update_date prof_last_update_date, prof.last_updated_by prof_last_updated_by, prof.creation_date prof_creation_date, prof.created_by prof_created_by, prof.last_update_login prof_last_update_login, prof.status prof_status, prof.collector_id prof_collector_id, prof.credit_analyst_id prof_credit_analyst_id, prof.credit_checking prof_credit_checking, prof.next_credit_review_date prof_next_credit_review_date, prof.tolerance prof_tolerance, prof.discount_terms prof_discount_terms, prof.dunning_letters prof_dunning_letters, prof.interest_charges prof_interest_charges, prof.send_statements prof_send_statements, prof.credit_balance_statements prof_credit_balance_statements, prof.credit_hold prof_credit_hold, prof.profile_class_id prof_profile_class_id, prof.site_use_id prof_site_use_id, prof.credit_rating prof_credit_rating, prof.risk_code prof_risk_code, prof.standard_terms prof_standard_terms, prof.override_terms prof_override_terms, prof.dunning_letter_set_id prof_dunning_letter_set_id, prof.interest_period_days prof_interest_period_days, prof.payment_grace_days prof_payment_grace_days, prof.discount_grace_days prof_discount_grace_days, prof.statement_cycle_id prof_statement_cycle_id, prof.account_status prof_account_status, prof.percent_collectable prof_percent_collectable, prof.autocash_hierarchy_id prof_autocash_hierarchy_id, prof.attribute_category prof_attribute_category, prof.attribute1 prof_attribute1, prof.attribute2 prof_attribute2, prof.attribute3 prof_attribute3, prof.attribute4 prof_attribute4, prof.attribute5 prof_attribute5, prof.attribute6 prof_attribute6, prof.attribute7 prof_attribute7, prof.attribute8 prof_attribute8, prof.attribute9 prof_attribute9, prof.attribute10 prof_attribute10, prof.attribute11 prof_attribute11, prof.attribute12 prof_attribute12, prof.attribute13 prof_attribute13, prof.attribute14 prof_attribute14, prof.attribute15 prof_attribute15, prof.auto_rec_incl_disputed_flag auto_rec_incl_disputed_flag, prof.tax_printing_option prof_tax_printing_option, prof.charge_on_finance_charge_flag charge_on_finance_charge_flag, prof.grouping_rule_id prof_grouping_rule_id, prof.clearing_days prof_clearing_days, prof.jgzz_attribute_category prof_jgzz_attribute_category, prof.jgzz_attribute1 prof_jgzz_attribute1, prof.jgzz_attribute2 prof_jgzz_attribute2, prof.jgzz_attribute3 prof_jgzz_attribute3, prof.jgzz_attribute4 prof_jgzz_attribute4, prof.jgzz_attribute5 prof_jgzz_attribute5, prof.jgzz_attribute6 prof_jgzz_attribute6, prof.jgzz_attribute7 prof_jgzz_attribute7, prof.jgzz_attribute8 prof_jgzz_attribute8, prof.jgzz_attribute9 prof_jgzz_attribute9, prof.jgzz_attribute10 prof_jgzz_attribute10, prof.jgzz_attribute11 prof_jgzz_attribute11, prof.jgzz_attribute12 prof_jgzz_attribute12, prof.jgzz_attribute13 prof_jgzz_attribute13, prof.jgzz_attribute14 prof_jgzz_attribute14, prof.jgzz_attribute15 prof_jgzz_attribute15, prof.global_attribute1 prof_global_attribute1, prof.global_attribute2 prof_global_attribute2, prof.global_attribute3 prof_global_attribute3, prof.global_attribute4 prof_global_attribute4, prof.global_attribute5 prof_global_attribute5, prof.global_attribute6 prof_global_attribute6, prof.global_attribute7 prof_global_attribute7, prof.global_attribute8 prof_global_attribute8, prof.global_attribute9 prof_global_attribute9, prof.global_attribute10 prof_global_attribute10, prof.global_attribute11 prof_global_attribute11, prof.global_attribute12 prof_global_attribute12, prof.global_attribute13 prof_global_attribute13, prof.global_attribute14 prof_global_attribute14, prof.global_attribute15 prof_global_attribute15, prof.global_attribute16 prof_global_attribute16, prof.global_attribute17 prof_global_attribute17, prof.global_attribute18 prof_global_attribute18, prof.global_attribute19 prof_global_attribute19, prof.global_attribute20 prof_global_attribute20, prof.global_attribute_category prof_global_attribute_category, prof.cons_inv_flag prof_cons_inv_flag, prof.cons_inv_type prof_cons_inv_type, prof.autocash_hierarchy_id_for_adr autocash_hierarchy_id_for_adr, prof.lockbox_matching_option prof_lockbox_matching_option, prof.created_by_module prof_created_by_module, prof.application_id prof_application_id, prof.review_cycle prof_review_cycle, prof.last_credit_review_date prof_last_credit_review_date, prof.party_id prof_party_id, prof.credit_classification prof_credit_classification, person.person_pre_name_adjunct per_person_pre_name_adjunct, person.person_first_name per_person_first_name, person.person_middle_name per_person_middle_name, person.person_last_name per_person_last_name, person.person_name_suffix per_person_name_suffix, person.person_title per_person_title, person.person_academic_title per_person_academic_title, person.person_previous_last_name per_person_previous_last_name, person.person_initials per_person_initials, person.known_as per_known_as, person.known_as2 per_known_as2, person.known_as3 per_known_as3, person.known_as4 per_known_as4, person.known_as5 per_known_as5, person.person_name_phonetic per_person_name_phonetic, person.person_first_name_phonetic per_person_first_name_phonetic, person.person_last_name_phonetic per_person_last_name_phonetic, person.middle_name_phonetic per_middle_name_phonetic, person.tax_reference per_tax_reference, person.jgzz_fiscal_code per_jgzz_fiscal_code, person.person_iden_type per_person_iden_type, person.person_identifier per_person_identifier, person.date_of_birth per_date_of_birth, person.deceased_flag per_deceased_ind, person.place_of_birth per_place_of_birth, person.date_of_death per_date_of_death, person.gender per_gender, person.declared_ethnicity per_declared_ethnicity, person.marital_status per_marital_status, person.marital_status_effective_date marital_status_effective_date, person.personal_income per_personal_income, person.head_of_household_flag per_head_of_household_flag, person.household_income per_household_income, person.household_size per_household_size, person.rent_own_ind per_rent_own_ind, person.last_known_gps per_last_known_gps, person.content_source_type per_content_source_type, person.internal_flag per_internal_flag, person.created_by_module per_created_by_module, person.application_id per_application_id, person.actual_content_source per_actual_content_source, party.party_id party_party_id, party.party_number party_party_number, party.validated_flag party_validated_flag, party.orig_system_reference party_orig_system_reference, 'PARTY_MOSR' party_orig_system, party.status party_status, party.last_update_date party_last_update_date, party.last_updated_by party_last_updated_by, party.creation_date party_creation_date, party.created_by party_created_by, party.last_update_login party_last_update_login, party.category_code party_category_code, party.salutation party_salutation, party.attribute_category party_attribute_category, party.attribute1 party_attribute1, party.attribute2 party_attribute2, party.attribute3 party_attribute3, party.attribute4 party_attribute4, party.attribute5 party_attribute5, party.attribute6 party_attribute6, party.attribute7 party_attribute7, party.attribute8 party_attribute8, party.attribute9 party_attribute9, party.attribute10 party_attribute10, party.attribute11 party_attribute11, party.attribute12 party_attribute12, party.attribute13 party_attribute13, party.attribute14 party_attribute14, party.attribute15 party_attribute15, party.attribute16 party_attribute16, party.attribute17 party_attribute17, party.attribute18 party_attribute18, party.attribute19 party_attribute19, party.attribute20 party_attribute20, party.attribute21 party_attribute21, party.attribute22 party_attribute22, party.attribute23 party_attribute23, party.attribute24 party_attribute24 from HZ_CUST_ACCOUNTS cust, HZ_CUSTOMER_PROFILES prof, HZ_PARTIES party, HZ_PERSON_PROFILES person WHERE person.party_id = party.party_id and person.effective_end_date is null and party.party_id= cust.party_id and cust.cust_account_id = prof.cust_account_id

View Text - HTML Formatted

SELECT CUST.CUST_ACCOUNT_ID CUST_CUST_ACCOUNT_ID
, CUST.ACCOUNT_NUMBER CUST_ACCOUNT_NUMBER
, CUST.LAST_UPDATE_DATE CUST_LAST_UPDATE_DATE
, CUST.LAST_UPDATED_BY CUST_LAST_UPDATED_BY
, CUST.CREATION_DATE CUST_CREATION_DATE
, CUST.CREATED_BY CUST_CREATED_BY
, CUST.LAST_UPDATE_LOGIN CUST_LAST_UPDATE_LOGIN
, CUST.ATTRIBUTE_CATEGORY CUST_ATTRIBUTE_CATEGORY
, CUST.ATTRIBUTE1 CUST_ATTRIBUTE1
, CUST.ATTRIBUTE2 CUST_ATTRIBUTE2
, CUST.ATTRIBUTE3 CUST_ATTRIBUTE3
, CUST.ATTRIBUTE4 CUST_ATTRIBUTE4
, CUST.ATTRIBUTE5 CUST_ATTRIBUTE5
, CUST.ATTRIBUTE6 CUST_ATTRIBUTE6
, CUST.ATTRIBUTE7 CUST_ATTRIBUTE7
, CUST.ATTRIBUTE8 CUST_ATTRIBUTE8
, CUST.ATTRIBUTE9 CUST_ATTRIBUTE9
, CUST.ATTRIBUTE10 CUST_ATTRIBUTE10
, CUST.ATTRIBUTE11 CUST_ATTRIBUTE11
, CUST.ATTRIBUTE12 CUST_ATTRIBUTE12
, CUST.ATTRIBUTE13 CUST_ATTRIBUTE13
, CUST.ATTRIBUTE14 CUST_ATTRIBUTE14
, CUST.ATTRIBUTE15 CUST_ATTRIBUTE15
, CUST.ATTRIBUTE16 CUST_ATTRIBUTE16
, CUST.ATTRIBUTE17 CUST_ATTRIBUTE17
, CUST.ATTRIBUTE18 CUST_ATTRIBUTE18
, CUST.ATTRIBUTE19 CUST_ATTRIBUTE19
, CUST.ATTRIBUTE20 CUST_ATTRIBUTE20
, CUST.GLOBAL_ATTRIBUTE_CATEGORY CUST_GLOBAL_ATTRIBUTE_CATEGORY
, CUST.GLOBAL_ATTRIBUTE1 CUST_GLOBAL_ATTRIBUTE1
, CUST.GLOBAL_ATTRIBUTE2 CUST_GLOBAL_ATTRIBUTE2
, CUST.GLOBAL_ATTRIBUTE3 CUST_GLOBAL_ATTRIBUTE3
, CUST.GLOBAL_ATTRIBUTE4 CUST_GLOBAL_ATTRIBUTE4
, CUST.GLOBAL_ATTRIBUTE5 CUST_GLOBAL_ATTRIBUTE5
, CUST.GLOBAL_ATTRIBUTE6 CUST_GLOBAL_ATTRIBUTE6
, CUST.GLOBAL_ATTRIBUTE7 CUST_GLOBAL_ATTRIBUTE7
, CUST.GLOBAL_ATTRIBUTE8 CUST_GLOBAL_ATTRIBUTE8
, CUST.GLOBAL_ATTRIBUTE9 CUST_GLOBAL_ATTRIBUTE9
, CUST.GLOBAL_ATTRIBUTE10 CUST_GLOBAL_ATTRIBUTE10
, CUST.GLOBAL_ATTRIBUTE11 CUST_GLOBAL_ATTRIBUTE11
, CUST.GLOBAL_ATTRIBUTE12 CUST_GLOBAL_ATTRIBUTE12
, CUST.GLOBAL_ATTRIBUTE13 CUST_GLOBAL_ATTRIBUTE13
, CUST.GLOBAL_ATTRIBUTE14 CUST_GLOBAL_ATTRIBUTE14
, CUST.GLOBAL_ATTRIBUTE15 CUST_GLOBAL_ATTRIBUTE15
, CUST.GLOBAL_ATTRIBUTE16 CUST_GLOBAL_ATTRIBUTE16
, CUST.GLOBAL_ATTRIBUTE17 CUST_GLOBAL_ATTRIBUTE17
, CUST.GLOBAL_ATTRIBUTE18 CUST_GLOBAL_ATTRIBUTE18
, CUST.GLOBAL_ATTRIBUTE19 CUST_GLOBAL_ATTRIBUTE19
, CUST.GLOBAL_ATTRIBUTE20 CUST_GLOBAL_ATTRIBUTE20
, CUST.ORIG_SYSTEM_REFERENCE CUST_ORIG_SYSTEM_REFERENCE
, 'CUST_MOSR' CUST_ORIG_SYSTEM
, CUST.STATUS CUST_STATUS
, CUST.CUSTOMER_TYPE CUST_CUSTOMER_TYPE
, CUST.CUSTOMER_CLASS_CODE CUST_CUSTOMER_CLASS_CODE
, CUST.PRIMARY_SALESREP_ID CUST_PRIMARY_SALESREP_ID
, CUST.SALES_CHANNEL_CODE CUST_SALES_CHANNEL_CODE
, CUST.ORDER_TYPE_ID CUST_ORDER_TYPE_ID
, CUST.PRICE_LIST_ID CUST_PRICE_LIST_ID
, CUST.TAX_CODE CUST_TAX_CODE
, CUST.FOB_POINT CUST_FOB_POINT
, CUST.FREIGHT_TERM CUST_FREIGHT_TERM
, CUST.SHIP_VIA CUST_SHIP_VIA
, CUST.WAREHOUSE_ID CUST_WAREHOUSE_ID
, CUST.TAX_HEADER_LEVEL_FLAG CUST_TAX_HEADER_LEVEL_FLAG
, CUST.TAX_ROUNDING_RULE CUST_TAX_ROUNDING_RULE
, CUST.COTERMINATE_DAY_MONTH CUST_COTERMINATE_DAY_MONTH
, CUST.PRIMARY_SPECIALIST_ID CUST_PRIMARY_SPECIALIST_ID
, CUST.SECONDARY_SPECIALIST_ID CUST_SECONDARY_SPECIALIST_ID
, CUST.ACCOUNT_LIABLE_FLAG CUST_ACCOUNT_LIABLE_FLAG
, CUST.CURRENT_BALANCE CUST_CURRENT_BALANCE
, CUST.ACCOUNT_ESTABLISHED_DATE CUST_ACCOUNT_ESTABLISHED_DATE
, CUST.ACCOUNT_TERMINATION_DATE CUST_ACCOUNT_TERMINATION_DATE
, CUST.ACCOUNT_ACTIVATION_DATE CUST_ACCOUNT_ACTIVATION_DATE
, CUST.DEPARTMENT CUST_DEPARTMENT
, CUST.HELD_BILL_EXPIRATION_DATE CUST_HELD_BILL_EXPIRATION_DATE
, CUST.HOLD_BILL_FLAG CUST_HOLD_BILL_FLAG
, CUST.REALTIME_RATE_FLAG CUST_REALTIME_RATE_FLAG
, CUST.ACCT_LIFE_CYCLE_STATUS CUST_ACCT_LIFE_CYCLE_STATUS
, CUST.ACCOUNT_NAME CUST_ACCOUNT_NAME
, CUST.DEPOSIT_REFUND_METHOD CUST_DEPOSIT_REFUND_METHOD
, CUST.DORMANT_ACCOUNT_FLAG CUST_DORMANT_ACCOUNT_FLAG
, CUST.NPA_NUMBER CUST_NPA_NUMBER
, CUST.SUSPENSION_DATE CUST_SUSPENSION_DATE
, CUST.SOURCE_CODE CUST_SOURCE_CODE
, CUST.COMMENTS CUST_COMMENTS
, CUST.DATES_NEGATIVE_TOLERANCE CUST_DATES_NEGATIVE_TOLERANCE
, CUST.DATES_POSITIVE_TOLERANCE CUST_DATES_POSITIVE_TOLERANCE
, CUST.DATE_TYPE_PREFERENCE CUST_DATE_TYPE_PREFERENCE
, CUST.OVER_SHIPMENT_TOLERANCE CUST_OVER_SHIPMENT_TOLERANCE
, CUST.UNDER_SHIPMENT_TOLERANCE CUST_UNDER_SHIPMENT_TOLERANCE
, CUST.OVER_RETURN_TOLERANCE CUST_OVER_RETURN_TOLERANCE
, CUST.UNDER_RETURN_TOLERANCE CUST_UNDER_RETURN_TOLERANCE
, CUST.ITEM_CROSS_REF_PREF CUST_ITEM_CROSS_REF_PREF
, CUST.SHIP_SETS_INCLUDE_LINES_FLAG SHIP_SETS_INCLUDE_LINES_FLAG
, CUST.ARRIVALSETS_INCLUDE_LINES_FLAG ARRIVALSETS_INCLUDE_LINES_FLAG
, CUST.SCHED_DATE_PUSH_FLAG CUST_SCHED_DATE_PUSH_FLAG
, CUST.INVOICE_QUANTITY_RULE CUST_INVOICE_QUANTITY_RULE
, CUST.STATUS_UPDATE_DATE CUST_STATUS_UPDATE_DATE
, CUST.AUTOPAY_FLAG CUST_AUTOPAY_FLAG
, CUST.NOTIFY_FLAG CUST_NOTIFY_FLAG
, CUST.LAST_BATCH_ID CUST_LAST_BATCH_ID
, CUST.SELLING_PARTY_ID CUST_SELLING_PARTY_ID
, CUST.CREATED_BY_MODULE CUST_CREATED_BY_MODULE
, CUST.APPLICATION_ID CUST_APPLICATION_ID
, CUST.OBJECT_VERSION_NUMBER CUST_OBJECT_VERSION_NUMBER
, PROF.CUST_ACCOUNT_PROFILE_ID PROF_CUST_ACCOUNT_PROFILE_ID
, PROF.LAST_UPDATE_DATE PROF_LAST_UPDATE_DATE
, PROF.LAST_UPDATED_BY PROF_LAST_UPDATED_BY
, PROF.CREATION_DATE PROF_CREATION_DATE
, PROF.CREATED_BY PROF_CREATED_BY
, PROF.LAST_UPDATE_LOGIN PROF_LAST_UPDATE_LOGIN
, PROF.STATUS PROF_STATUS
, PROF.COLLECTOR_ID PROF_COLLECTOR_ID
, PROF.CREDIT_ANALYST_ID PROF_CREDIT_ANALYST_ID
, PROF.CREDIT_CHECKING PROF_CREDIT_CHECKING
, PROF.NEXT_CREDIT_REVIEW_DATE PROF_NEXT_CREDIT_REVIEW_DATE
, PROF.TOLERANCE PROF_TOLERANCE
, PROF.DISCOUNT_TERMS PROF_DISCOUNT_TERMS
, PROF.DUNNING_LETTERS PROF_DUNNING_LETTERS
, PROF.INTEREST_CHARGES PROF_INTEREST_CHARGES
, PROF.SEND_STATEMENTS PROF_SEND_STATEMENTS
, PROF.CREDIT_BALANCE_STATEMENTS PROF_CREDIT_BALANCE_STATEMENTS
, PROF.CREDIT_HOLD PROF_CREDIT_HOLD
, PROF.PROFILE_CLASS_ID PROF_PROFILE_CLASS_ID
, PROF.SITE_USE_ID PROF_SITE_USE_ID
, PROF.CREDIT_RATING PROF_CREDIT_RATING
, PROF.RISK_CODE PROF_RISK_CODE
, PROF.STANDARD_TERMS PROF_STANDARD_TERMS
, PROF.OVERRIDE_TERMS PROF_OVERRIDE_TERMS
, PROF.DUNNING_LETTER_SET_ID PROF_DUNNING_LETTER_SET_ID
, PROF.INTEREST_PERIOD_DAYS PROF_INTEREST_PERIOD_DAYS
, PROF.PAYMENT_GRACE_DAYS PROF_PAYMENT_GRACE_DAYS
, PROF.DISCOUNT_GRACE_DAYS PROF_DISCOUNT_GRACE_DAYS
, PROF.STATEMENT_CYCLE_ID PROF_STATEMENT_CYCLE_ID
, PROF.ACCOUNT_STATUS PROF_ACCOUNT_STATUS
, PROF.PERCENT_COLLECTABLE PROF_PERCENT_COLLECTABLE
, PROF.AUTOCASH_HIERARCHY_ID PROF_AUTOCASH_HIERARCHY_ID
, PROF.ATTRIBUTE_CATEGORY PROF_ATTRIBUTE_CATEGORY
, PROF.ATTRIBUTE1 PROF_ATTRIBUTE1
, PROF.ATTRIBUTE2 PROF_ATTRIBUTE2
, PROF.ATTRIBUTE3 PROF_ATTRIBUTE3
, PROF.ATTRIBUTE4 PROF_ATTRIBUTE4
, PROF.ATTRIBUTE5 PROF_ATTRIBUTE5
, PROF.ATTRIBUTE6 PROF_ATTRIBUTE6
, PROF.ATTRIBUTE7 PROF_ATTRIBUTE7
, PROF.ATTRIBUTE8 PROF_ATTRIBUTE8
, PROF.ATTRIBUTE9 PROF_ATTRIBUTE9
, PROF.ATTRIBUTE10 PROF_ATTRIBUTE10
, PROF.ATTRIBUTE11 PROF_ATTRIBUTE11
, PROF.ATTRIBUTE12 PROF_ATTRIBUTE12
, PROF.ATTRIBUTE13 PROF_ATTRIBUTE13
, PROF.ATTRIBUTE14 PROF_ATTRIBUTE14
, PROF.ATTRIBUTE15 PROF_ATTRIBUTE15
, PROF.AUTO_REC_INCL_DISPUTED_FLAG AUTO_REC_INCL_DISPUTED_FLAG
, PROF.TAX_PRINTING_OPTION PROF_TAX_PRINTING_OPTION
, PROF.CHARGE_ON_FINANCE_CHARGE_FLAG CHARGE_ON_FINANCE_CHARGE_FLAG
, PROF.GROUPING_RULE_ID PROF_GROUPING_RULE_ID
, PROF.CLEARING_DAYS PROF_CLEARING_DAYS
, PROF.JGZZ_ATTRIBUTE_CATEGORY PROF_JGZZ_ATTRIBUTE_CATEGORY
, PROF.JGZZ_ATTRIBUTE1 PROF_JGZZ_ATTRIBUTE1
, PROF.JGZZ_ATTRIBUTE2 PROF_JGZZ_ATTRIBUTE2
, PROF.JGZZ_ATTRIBUTE3 PROF_JGZZ_ATTRIBUTE3
, PROF.JGZZ_ATTRIBUTE4 PROF_JGZZ_ATTRIBUTE4
, PROF.JGZZ_ATTRIBUTE5 PROF_JGZZ_ATTRIBUTE5
, PROF.JGZZ_ATTRIBUTE6 PROF_JGZZ_ATTRIBUTE6
, PROF.JGZZ_ATTRIBUTE7 PROF_JGZZ_ATTRIBUTE7
, PROF.JGZZ_ATTRIBUTE8 PROF_JGZZ_ATTRIBUTE8
, PROF.JGZZ_ATTRIBUTE9 PROF_JGZZ_ATTRIBUTE9
, PROF.JGZZ_ATTRIBUTE10 PROF_JGZZ_ATTRIBUTE10
, PROF.JGZZ_ATTRIBUTE11 PROF_JGZZ_ATTRIBUTE11
, PROF.JGZZ_ATTRIBUTE12 PROF_JGZZ_ATTRIBUTE12
, PROF.JGZZ_ATTRIBUTE13 PROF_JGZZ_ATTRIBUTE13
, PROF.JGZZ_ATTRIBUTE14 PROF_JGZZ_ATTRIBUTE14
, PROF.JGZZ_ATTRIBUTE15 PROF_JGZZ_ATTRIBUTE15
, PROF.GLOBAL_ATTRIBUTE1 PROF_GLOBAL_ATTRIBUTE1
, PROF.GLOBAL_ATTRIBUTE2 PROF_GLOBAL_ATTRIBUTE2
, PROF.GLOBAL_ATTRIBUTE3 PROF_GLOBAL_ATTRIBUTE3
, PROF.GLOBAL_ATTRIBUTE4 PROF_GLOBAL_ATTRIBUTE4
, PROF.GLOBAL_ATTRIBUTE5 PROF_GLOBAL_ATTRIBUTE5
, PROF.GLOBAL_ATTRIBUTE6 PROF_GLOBAL_ATTRIBUTE6
, PROF.GLOBAL_ATTRIBUTE7 PROF_GLOBAL_ATTRIBUTE7
, PROF.GLOBAL_ATTRIBUTE8 PROF_GLOBAL_ATTRIBUTE8
, PROF.GLOBAL_ATTRIBUTE9 PROF_GLOBAL_ATTRIBUTE9
, PROF.GLOBAL_ATTRIBUTE10 PROF_GLOBAL_ATTRIBUTE10
, PROF.GLOBAL_ATTRIBUTE11 PROF_GLOBAL_ATTRIBUTE11
, PROF.GLOBAL_ATTRIBUTE12 PROF_GLOBAL_ATTRIBUTE12
, PROF.GLOBAL_ATTRIBUTE13 PROF_GLOBAL_ATTRIBUTE13
, PROF.GLOBAL_ATTRIBUTE14 PROF_GLOBAL_ATTRIBUTE14
, PROF.GLOBAL_ATTRIBUTE15 PROF_GLOBAL_ATTRIBUTE15
, PROF.GLOBAL_ATTRIBUTE16 PROF_GLOBAL_ATTRIBUTE16
, PROF.GLOBAL_ATTRIBUTE17 PROF_GLOBAL_ATTRIBUTE17
, PROF.GLOBAL_ATTRIBUTE18 PROF_GLOBAL_ATTRIBUTE18
, PROF.GLOBAL_ATTRIBUTE19 PROF_GLOBAL_ATTRIBUTE19
, PROF.GLOBAL_ATTRIBUTE20 PROF_GLOBAL_ATTRIBUTE20
, PROF.GLOBAL_ATTRIBUTE_CATEGORY PROF_GLOBAL_ATTRIBUTE_CATEGORY
, PROF.CONS_INV_FLAG PROF_CONS_INV_FLAG
, PROF.CONS_INV_TYPE PROF_CONS_INV_TYPE
, PROF.AUTOCASH_HIERARCHY_ID_FOR_ADR AUTOCASH_HIERARCHY_ID_FOR_ADR
, PROF.LOCKBOX_MATCHING_OPTION PROF_LOCKBOX_MATCHING_OPTION
, PROF.CREATED_BY_MODULE PROF_CREATED_BY_MODULE
, PROF.APPLICATION_ID PROF_APPLICATION_ID
, PROF.REVIEW_CYCLE PROF_REVIEW_CYCLE
, PROF.LAST_CREDIT_REVIEW_DATE PROF_LAST_CREDIT_REVIEW_DATE
, PROF.PARTY_ID PROF_PARTY_ID
, PROF.CREDIT_CLASSIFICATION PROF_CREDIT_CLASSIFICATION
, PERSON.PERSON_PRE_NAME_ADJUNCT PER_PERSON_PRE_NAME_ADJUNCT
, PERSON.PERSON_FIRST_NAME PER_PERSON_FIRST_NAME
, PERSON.PERSON_MIDDLE_NAME PER_PERSON_MIDDLE_NAME
, PERSON.PERSON_LAST_NAME PER_PERSON_LAST_NAME
, PERSON.PERSON_NAME_SUFFIX PER_PERSON_NAME_SUFFIX
, PERSON.PERSON_TITLE PER_PERSON_TITLE
, PERSON.PERSON_ACADEMIC_TITLE PER_PERSON_ACADEMIC_TITLE
, PERSON.PERSON_PREVIOUS_LAST_NAME PER_PERSON_PREVIOUS_LAST_NAME
, PERSON.PERSON_INITIALS PER_PERSON_INITIALS
, PERSON.KNOWN_AS PER_KNOWN_AS
, PERSON.KNOWN_AS2 PER_KNOWN_AS2
, PERSON.KNOWN_AS3 PER_KNOWN_AS3
, PERSON.KNOWN_AS4 PER_KNOWN_AS4
, PERSON.KNOWN_AS5 PER_KNOWN_AS5
, PERSON.PERSON_NAME_PHONETIC PER_PERSON_NAME_PHONETIC
, PERSON.PERSON_FIRST_NAME_PHONETIC PER_PERSON_FIRST_NAME_PHONETIC
, PERSON.PERSON_LAST_NAME_PHONETIC PER_PERSON_LAST_NAME_PHONETIC
, PERSON.MIDDLE_NAME_PHONETIC PER_MIDDLE_NAME_PHONETIC
, PERSON.TAX_REFERENCE PER_TAX_REFERENCE
, PERSON.JGZZ_FISCAL_CODE PER_JGZZ_FISCAL_CODE
, PERSON.PERSON_IDEN_TYPE PER_PERSON_IDEN_TYPE
, PERSON.PERSON_IDENTIFIER PER_PERSON_IDENTIFIER
, PERSON.DATE_OF_BIRTH PER_DATE_OF_BIRTH
, PERSON.DECEASED_FLAG PER_DECEASED_IND
, PERSON.PLACE_OF_BIRTH PER_PLACE_OF_BIRTH
, PERSON.DATE_OF_DEATH PER_DATE_OF_DEATH
, PERSON.GENDER PER_GENDER
, PERSON.DECLARED_ETHNICITY PER_DECLARED_ETHNICITY
, PERSON.MARITAL_STATUS PER_MARITAL_STATUS
, PERSON.MARITAL_STATUS_EFFECTIVE_DATE MARITAL_STATUS_EFFECTIVE_DATE
, PERSON.PERSONAL_INCOME PER_PERSONAL_INCOME
, PERSON.HEAD_OF_HOUSEHOLD_FLAG PER_HEAD_OF_HOUSEHOLD_FLAG
, PERSON.HOUSEHOLD_INCOME PER_HOUSEHOLD_INCOME
, PERSON.HOUSEHOLD_SIZE PER_HOUSEHOLD_SIZE
, PERSON.RENT_OWN_IND PER_RENT_OWN_IND
, PERSON.LAST_KNOWN_GPS PER_LAST_KNOWN_GPS
, PERSON.CONTENT_SOURCE_TYPE PER_CONTENT_SOURCE_TYPE
, PERSON.INTERNAL_FLAG PER_INTERNAL_FLAG
, PERSON.CREATED_BY_MODULE PER_CREATED_BY_MODULE
, PERSON.APPLICATION_ID PER_APPLICATION_ID
, PERSON.ACTUAL_CONTENT_SOURCE PER_ACTUAL_CONTENT_SOURCE
, PARTY.PARTY_ID PARTY_PARTY_ID
, PARTY.PARTY_NUMBER PARTY_PARTY_NUMBER
, PARTY.VALIDATED_FLAG PARTY_VALIDATED_FLAG
, PARTY.ORIG_SYSTEM_REFERENCE PARTY_ORIG_SYSTEM_REFERENCE
, 'PARTY_MOSR' PARTY_ORIG_SYSTEM
, PARTY.STATUS PARTY_STATUS
, PARTY.LAST_UPDATE_DATE PARTY_LAST_UPDATE_DATE
, PARTY.LAST_UPDATED_BY PARTY_LAST_UPDATED_BY
, PARTY.CREATION_DATE PARTY_CREATION_DATE
, PARTY.CREATED_BY PARTY_CREATED_BY
, PARTY.LAST_UPDATE_LOGIN PARTY_LAST_UPDATE_LOGIN
, PARTY.CATEGORY_CODE PARTY_CATEGORY_CODE
, PARTY.SALUTATION PARTY_SALUTATION
, PARTY.ATTRIBUTE_CATEGORY PARTY_ATTRIBUTE_CATEGORY
, PARTY.ATTRIBUTE1 PARTY_ATTRIBUTE1
, PARTY.ATTRIBUTE2 PARTY_ATTRIBUTE2
, PARTY.ATTRIBUTE3 PARTY_ATTRIBUTE3
, PARTY.ATTRIBUTE4 PARTY_ATTRIBUTE4
, PARTY.ATTRIBUTE5 PARTY_ATTRIBUTE5
, PARTY.ATTRIBUTE6 PARTY_ATTRIBUTE6
, PARTY.ATTRIBUTE7 PARTY_ATTRIBUTE7
, PARTY.ATTRIBUTE8 PARTY_ATTRIBUTE8
, PARTY.ATTRIBUTE9 PARTY_ATTRIBUTE9
, PARTY.ATTRIBUTE10 PARTY_ATTRIBUTE10
, PARTY.ATTRIBUTE11 PARTY_ATTRIBUTE11
, PARTY.ATTRIBUTE12 PARTY_ATTRIBUTE12
, PARTY.ATTRIBUTE13 PARTY_ATTRIBUTE13
, PARTY.ATTRIBUTE14 PARTY_ATTRIBUTE14
, PARTY.ATTRIBUTE15 PARTY_ATTRIBUTE15
, PARTY.ATTRIBUTE16 PARTY_ATTRIBUTE16
, PARTY.ATTRIBUTE17 PARTY_ATTRIBUTE17
, PARTY.ATTRIBUTE18 PARTY_ATTRIBUTE18
, PARTY.ATTRIBUTE19 PARTY_ATTRIBUTE19
, PARTY.ATTRIBUTE20 PARTY_ATTRIBUTE20
, PARTY.ATTRIBUTE21 PARTY_ATTRIBUTE21
, PARTY.ATTRIBUTE22 PARTY_ATTRIBUTE22
, PARTY.ATTRIBUTE23 PARTY_ATTRIBUTE23
, PARTY.ATTRIBUTE24 PARTY_ATTRIBUTE24
FROM HZ_CUST_ACCOUNTS CUST
, HZ_CUSTOMER_PROFILES PROF
, HZ_PARTIES PARTY
, HZ_PERSON_PROFILES PERSON
WHERE PERSON.PARTY_ID = PARTY.PARTY_ID
AND PERSON.EFFECTIVE_END_DATE IS NULL
AND PARTY.PARTY_ID= CUST.PARTY_ID
AND CUST.CUST_ACCOUNT_ID = PROF.CUST_ACCOUNT_ID