View: HZ_WSRVC_ORG_ACCOUNT_V

Product:	AR - Receivables
Description:	Internal view for Organization Account
Implementation/DBA Data:	APPS.HZ_WSRVC_ORG_ACCOUNT_V

View Text

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

Columns