VIEW: APPS.HZ_WSRVC_ORG_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, org.organization_name org_organization_name, org.duns_number_c org_duns_number_c, org.enquiry_duns org_enquiry_duns, org.ceo_name org_ceo_name, org.ceo_title org_ceo_title, org.principal_name org_principal_name, org.principal_title org_principal_title, org.legal_status org_legal_status, org.control_yr org_control_yr, org.employees_total org_employees_total, org.hq_branch_ind org_hq_branch_ind, org.branch_flag org_branch_flag, org.oob_ind org_oob_ind, org.line_of_business org_line_of_business, org.cong_dist_code org_cong_dist_code, org.sic_code org_sic_code, org.import_ind org_import_ind, org.export_ind org_export_ind, org.labor_surplus_ind org_labor_surplus_ind, org.debarment_ind org_debarment_ind, org.minority_owned_ind org_minority_owned_ind, org.minority_owned_type org_minority_owned_type, org.woman_owned_ind org_woman_owned_ind, org.disadv_8a_ind org_disadv_8a_ind, org.small_bus_ind org_small_bus_ind, org.rent_own_ind org_rent_own_ind, org.debarments_count org_debarments_count, org.debarments_date org_debarments_date, org.failure_score org_failure_score, org.failure_score_natnl_percentile failure_score_natnl_percentile, org.failure_score_override_code failure_score_override_code, org.failure_score_commentary org_failure_score_commentary, org.global_failure_score org_global_failure_score, org.db_rating org_db_rating, org.credit_score org_credit_score, org.credit_score_commentary org_credit_score_commentary, org.paydex_score org_paydex_score, org.paydex_three_months_ago org_paydex_three_months_ago, org.paydex_norm org_paydex_norm, org.best_time_contact_begin org_best_time_contact_begin, org.best_time_contact_end org_best_time_contact_end, org.organization_name_phonetic org_organization_name_phonetic, org.tax_reference org_tax_reference, org.gsa_indicator_flag org_gsa_indicator_flag, org.jgzz_fiscal_code org_jgzz_fiscal_code, org.analysis_fy org_analysis_fy, org.fiscal_yearend_month org_fiscal_yearend_month, org.curr_fy_potential_revenue org_curr_fy_potential_revenue, org.next_fy_potential_revenue org_next_fy_potential_revenue, org.year_established org_year_established, org.mission_statement org_mission_statement, org.organization_type org_organization_type, org.business_scope org_business_scope, org.corporation_class org_corporation_class, org.known_as org_known_as, org.known_as2 org_known_as2, org.known_as3 org_known_as3, org.known_as4 org_known_as4, org.known_as5 org_known_as5, org.local_bus_iden_type org_local_bus_iden_type, org.local_bus_identifier org_local_bus_identifier, org.pref_functional_currency org_pref_functional_currency, org.registration_type org_registration_type, org.total_employees_text org_total_employees_text, org.total_employees_ind org_total_employees_ind, org.total_emp_est_ind org_total_emp_est_ind, org.total_emp_min_ind org_total_emp_min_ind, org.parent_sub_ind org_parent_sub_ind, org.incorp_year org_incorp_year, org.sic_code_type org_sic_code_type, org.public_private_ownership_flag public_private_ownership_flag, org.internal_flag org_internal_flag, org.local_activity_code_type local_activity_code_type, org.local_activity_code org_local_activity_code, org.emp_at_primary_adr org_emp_at_primary_adr, org.emp_at_primary_adr_text emp_at_primary_adr_text, org.emp_at_primary_adr_est_ind emp_at_primary_adr_est_ind, org.emp_at_primary_adr_min_ind emp_at_primary_adr_min_ind, org.high_credit org_high_credit, org.avg_high_credit org_avg_high_credit, org.total_payments org_total_payments, org.credit_score_class org_credit_score_class, org.credit_score_natl_percentile credit_score_natl_percentile, org.credit_score_incd_default credit_score_incd_default, org.credit_score_age org_credit_score_age, org.credit_score_date org_credit_score_date, org.credit_score_commentary2 org_credit_score_commentary2, org.credit_score_commentary3 org_credit_score_commentary3, org.credit_score_commentary4 org_credit_score_commentary4, org.credit_score_commentary5 org_credit_score_commentary5, org.credit_score_commentary6 org_credit_score_commentary6, org.credit_score_commentary7 org_credit_score_commentary7, org.credit_score_commentary8 org_credit_score_commentary8, org.credit_score_commentary9 org_credit_score_commentary9, org.credit_score_commentary10 org_credit_score_commentary10, org.failure_score_class failure_score_class, org.failure_score_incd_default failure_score_incd_default, org.failure_score_age org_failure_score_age, org.failure_score_date org_failure_score_date, org.failure_score_commentary2 org_failure_score_commentary2, org.failure_score_commentary3 org_failure_score_commentary3, org.failure_score_commentary4 org_failure_score_commentary4, org.failure_score_commentary5 org_failure_score_commentary5, org.failure_score_commentary6 org_failure_score_commentary6, org.failure_score_commentary7 org_failure_score_commentary7, org.failure_score_commentary8 org_failure_score_commentary8, org.failure_score_commentary9 org_failure_score_commentary9, org.failure_score_commentary10 org_failure_score_commentary10, org.maximum_credit_recommendation maximum_credit_recommendation, org.maximum_credit_currency_code maximum_credit_currency_code, org.displayed_duns_party_id displayed_duns_party_id, org.content_source_type org_content_source_type, org.content_source_number org_content_source_number, org.created_by_module org_created_by_module, org.application_id org_application_id, org.do_not_confuse_with org_do_not_confuse_with, org.actual_content_source org_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_ORGANIZATION_PROFILES org WHERE org.party_id = party.party_id and org.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
, ORG.ORGANIZATION_NAME ORG_ORGANIZATION_NAME
, ORG.DUNS_NUMBER_C ORG_DUNS_NUMBER_C
, ORG.ENQUIRY_DUNS ORG_ENQUIRY_DUNS
, ORG.CEO_NAME ORG_CEO_NAME
, ORG.CEO_TITLE ORG_CEO_TITLE
, ORG.PRINCIPAL_NAME ORG_PRINCIPAL_NAME
, ORG.PRINCIPAL_TITLE ORG_PRINCIPAL_TITLE
, ORG.LEGAL_STATUS ORG_LEGAL_STATUS
, ORG.CONTROL_YR ORG_CONTROL_YR
, ORG.EMPLOYEES_TOTAL ORG_EMPLOYEES_TOTAL
, ORG.HQ_BRANCH_IND ORG_HQ_BRANCH_IND
, ORG.BRANCH_FLAG ORG_BRANCH_FLAG
, ORG.OOB_IND ORG_OOB_IND
, ORG.LINE_OF_BUSINESS ORG_LINE_OF_BUSINESS
, ORG.CONG_DIST_CODE ORG_CONG_DIST_CODE
, ORG.SIC_CODE ORG_SIC_CODE
, ORG.IMPORT_IND ORG_IMPORT_IND
, ORG.EXPORT_IND ORG_EXPORT_IND
, ORG.LABOR_SURPLUS_IND ORG_LABOR_SURPLUS_IND
, ORG.DEBARMENT_IND ORG_DEBARMENT_IND
, ORG.MINORITY_OWNED_IND ORG_MINORITY_OWNED_IND
, ORG.MINORITY_OWNED_TYPE ORG_MINORITY_OWNED_TYPE
, ORG.WOMAN_OWNED_IND ORG_WOMAN_OWNED_IND
, ORG.DISADV_8A_IND ORG_DISADV_8A_IND
, ORG.SMALL_BUS_IND ORG_SMALL_BUS_IND
, ORG.RENT_OWN_IND ORG_RENT_OWN_IND
, ORG.DEBARMENTS_COUNT ORG_DEBARMENTS_COUNT
, ORG.DEBARMENTS_DATE ORG_DEBARMENTS_DATE
, ORG.FAILURE_SCORE ORG_FAILURE_SCORE
, ORG.FAILURE_SCORE_NATNL_PERCENTILE FAILURE_SCORE_NATNL_PERCENTILE
, ORG.FAILURE_SCORE_OVERRIDE_CODE FAILURE_SCORE_OVERRIDE_CODE
, ORG.FAILURE_SCORE_COMMENTARY ORG_FAILURE_SCORE_COMMENTARY
, ORG.GLOBAL_FAILURE_SCORE ORG_GLOBAL_FAILURE_SCORE
, ORG.DB_RATING ORG_DB_RATING
, ORG.CREDIT_SCORE ORG_CREDIT_SCORE
, ORG.CREDIT_SCORE_COMMENTARY ORG_CREDIT_SCORE_COMMENTARY
, ORG.PAYDEX_SCORE ORG_PAYDEX_SCORE
, ORG.PAYDEX_THREE_MONTHS_AGO ORG_PAYDEX_THREE_MONTHS_AGO
, ORG.PAYDEX_NORM ORG_PAYDEX_NORM
, ORG.BEST_TIME_CONTACT_BEGIN ORG_BEST_TIME_CONTACT_BEGIN
, ORG.BEST_TIME_CONTACT_END ORG_BEST_TIME_CONTACT_END
, ORG.ORGANIZATION_NAME_PHONETIC ORG_ORGANIZATION_NAME_PHONETIC
, ORG.TAX_REFERENCE ORG_TAX_REFERENCE
, ORG.GSA_INDICATOR_FLAG ORG_GSA_INDICATOR_FLAG
, ORG.JGZZ_FISCAL_CODE ORG_JGZZ_FISCAL_CODE
, ORG.ANALYSIS_FY ORG_ANALYSIS_FY
, ORG.FISCAL_YEAREND_MONTH ORG_FISCAL_YEAREND_MONTH
, ORG.CURR_FY_POTENTIAL_REVENUE ORG_CURR_FY_POTENTIAL_REVENUE
, ORG.NEXT_FY_POTENTIAL_REVENUE ORG_NEXT_FY_POTENTIAL_REVENUE
, ORG.YEAR_ESTABLISHED ORG_YEAR_ESTABLISHED
, ORG.MISSION_STATEMENT ORG_MISSION_STATEMENT
, ORG.ORGANIZATION_TYPE ORG_ORGANIZATION_TYPE
, ORG.BUSINESS_SCOPE ORG_BUSINESS_SCOPE
, ORG.CORPORATION_CLASS ORG_CORPORATION_CLASS
, ORG.KNOWN_AS ORG_KNOWN_AS
, ORG.KNOWN_AS2 ORG_KNOWN_AS2
, ORG.KNOWN_AS3 ORG_KNOWN_AS3
, ORG.KNOWN_AS4 ORG_KNOWN_AS4
, ORG.KNOWN_AS5 ORG_KNOWN_AS5
, ORG.LOCAL_BUS_IDEN_TYPE ORG_LOCAL_BUS_IDEN_TYPE
, ORG.LOCAL_BUS_IDENTIFIER ORG_LOCAL_BUS_IDENTIFIER
, ORG.PREF_FUNCTIONAL_CURRENCY ORG_PREF_FUNCTIONAL_CURRENCY
, ORG.REGISTRATION_TYPE ORG_REGISTRATION_TYPE
, ORG.TOTAL_EMPLOYEES_TEXT ORG_TOTAL_EMPLOYEES_TEXT
, ORG.TOTAL_EMPLOYEES_IND ORG_TOTAL_EMPLOYEES_IND
, ORG.TOTAL_EMP_EST_IND ORG_TOTAL_EMP_EST_IND
, ORG.TOTAL_EMP_MIN_IND ORG_TOTAL_EMP_MIN_IND
, ORG.PARENT_SUB_IND ORG_PARENT_SUB_IND
, ORG.INCORP_YEAR ORG_INCORP_YEAR
, ORG.SIC_CODE_TYPE ORG_SIC_CODE_TYPE
, ORG.PUBLIC_PRIVATE_OWNERSHIP_FLAG PUBLIC_PRIVATE_OWNERSHIP_FLAG
, ORG.INTERNAL_FLAG ORG_INTERNAL_FLAG
, ORG.LOCAL_ACTIVITY_CODE_TYPE LOCAL_ACTIVITY_CODE_TYPE
, ORG.LOCAL_ACTIVITY_CODE ORG_LOCAL_ACTIVITY_CODE
, ORG.EMP_AT_PRIMARY_ADR ORG_EMP_AT_PRIMARY_ADR
, ORG.EMP_AT_PRIMARY_ADR_TEXT EMP_AT_PRIMARY_ADR_TEXT
, ORG.EMP_AT_PRIMARY_ADR_EST_IND EMP_AT_PRIMARY_ADR_EST_IND
, ORG.EMP_AT_PRIMARY_ADR_MIN_IND EMP_AT_PRIMARY_ADR_MIN_IND
, ORG.HIGH_CREDIT ORG_HIGH_CREDIT
, ORG.AVG_HIGH_CREDIT ORG_AVG_HIGH_CREDIT
, ORG.TOTAL_PAYMENTS ORG_TOTAL_PAYMENTS
, ORG.CREDIT_SCORE_CLASS ORG_CREDIT_SCORE_CLASS
, ORG.CREDIT_SCORE_NATL_PERCENTILE CREDIT_SCORE_NATL_PERCENTILE
, ORG.CREDIT_SCORE_INCD_DEFAULT CREDIT_SCORE_INCD_DEFAULT
, ORG.CREDIT_SCORE_AGE ORG_CREDIT_SCORE_AGE
, ORG.CREDIT_SCORE_DATE ORG_CREDIT_SCORE_DATE
, ORG.CREDIT_SCORE_COMMENTARY2 ORG_CREDIT_SCORE_COMMENTARY2
, ORG.CREDIT_SCORE_COMMENTARY3 ORG_CREDIT_SCORE_COMMENTARY3
, ORG.CREDIT_SCORE_COMMENTARY4 ORG_CREDIT_SCORE_COMMENTARY4
, ORG.CREDIT_SCORE_COMMENTARY5 ORG_CREDIT_SCORE_COMMENTARY5
, ORG.CREDIT_SCORE_COMMENTARY6 ORG_CREDIT_SCORE_COMMENTARY6
, ORG.CREDIT_SCORE_COMMENTARY7 ORG_CREDIT_SCORE_COMMENTARY7
, ORG.CREDIT_SCORE_COMMENTARY8 ORG_CREDIT_SCORE_COMMENTARY8
, ORG.CREDIT_SCORE_COMMENTARY9 ORG_CREDIT_SCORE_COMMENTARY9
, ORG.CREDIT_SCORE_COMMENTARY10 ORG_CREDIT_SCORE_COMMENTARY10
, ORG.FAILURE_SCORE_CLASS FAILURE_SCORE_CLASS
, ORG.FAILURE_SCORE_INCD_DEFAULT FAILURE_SCORE_INCD_DEFAULT
, ORG.FAILURE_SCORE_AGE ORG_FAILURE_SCORE_AGE
, ORG.FAILURE_SCORE_DATE ORG_FAILURE_SCORE_DATE
, ORG.FAILURE_SCORE_COMMENTARY2 ORG_FAILURE_SCORE_COMMENTARY2
, ORG.FAILURE_SCORE_COMMENTARY3 ORG_FAILURE_SCORE_COMMENTARY3
, ORG.FAILURE_SCORE_COMMENTARY4 ORG_FAILURE_SCORE_COMMENTARY4
, ORG.FAILURE_SCORE_COMMENTARY5 ORG_FAILURE_SCORE_COMMENTARY5
, ORG.FAILURE_SCORE_COMMENTARY6 ORG_FAILURE_SCORE_COMMENTARY6
, ORG.FAILURE_SCORE_COMMENTARY7 ORG_FAILURE_SCORE_COMMENTARY7
, ORG.FAILURE_SCORE_COMMENTARY8 ORG_FAILURE_SCORE_COMMENTARY8
, ORG.FAILURE_SCORE_COMMENTARY9 ORG_FAILURE_SCORE_COMMENTARY9
, ORG.FAILURE_SCORE_COMMENTARY10 ORG_FAILURE_SCORE_COMMENTARY10
, ORG.MAXIMUM_CREDIT_RECOMMENDATION MAXIMUM_CREDIT_RECOMMENDATION
, ORG.MAXIMUM_CREDIT_CURRENCY_CODE MAXIMUM_CREDIT_CURRENCY_CODE
, ORG.DISPLAYED_DUNS_PARTY_ID DISPLAYED_DUNS_PARTY_ID
, ORG.CONTENT_SOURCE_TYPE ORG_CONTENT_SOURCE_TYPE
, ORG.CONTENT_SOURCE_NUMBER ORG_CONTENT_SOURCE_NUMBER
, ORG.CREATED_BY_MODULE ORG_CREATED_BY_MODULE
, ORG.APPLICATION_ID ORG_APPLICATION_ID
, ORG.DO_NOT_CONFUSE_WITH ORG_DO_NOT_CONFUSE_WITH
, ORG.ACTUAL_CONTENT_SOURCE ORG_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_ORGANIZATION_PROFILES ORG
WHERE ORG.PARTY_ID = PARTY.PARTY_ID
AND ORG.EFFECTIVE_END_DATE IS NULL
AND PARTY.PARTY_ID= CUST.PARTY_ID
AND CUST.CUST_ACCOUNT_ID = PROF.CUST_ACCOUNT_ID