View: HZ_WSRVC_PERSON_ACCOUNT_V

Product:	AR - Receivables
Description:	Internal view for Person Account
Implementation/DBA Data:	APPS.HZ_WSRVC_PERSON_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
, 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

Columns