View: RA_HCUSTOMERS

View Text

SELECT CUST_ACCT.ROWID
, CUST_ACCT.CUST_ACCOUNT_ID
, PARTY.PARTY_ID
, PARTY.PARTY_NUMBER
, PARTY.PARTY_TYPE
, CUST_ACCT.LAST_UPDATE_DATE
, CUST_ACCT.LAST_UPDATED_BY
, CUST_ACCT.CREATION_DATE
, CUST_ACCT.CREATED_BY
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) /* CUSTOMER_NAME */
, CUST_ACCT.ACCOUNT_NUMBER /* CUSTOMER NUMBER */
, CUST_ACCT.ORIG_SYSTEM_REFERENCE
, CUST_ACCT.STATUS
, CUST_ACCT.LAST_UPDATE_LOGIN
, CUST_ACCT.CUSTOMER_TYPE
, 'CUSTOMER'
, CUST_ACCT.CUSTOMER_CLASS_CODE
, CUST_ACCT.PRIMARY_SALESREP_ID
, CUST_ACCT.SALES_CHANNEL_CODE
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.SIC_CODE
, NULL)
, CUST_ACCT.ORDER_TYPE_ID
, CUST_ACCT.PRICE_LIST_ID
, CUST_ACCT.ATTRIBUTE_CATEGORY
, CUST_ACCT.ATTRIBUTE1
, CUST_ACCT.ATTRIBUTE2
, CUST_ACCT.ATTRIBUTE3
, CUST_ACCT.ATTRIBUTE4
, CUST_ACCT.ATTRIBUTE5
, CUST_ACCT.ATTRIBUTE6
, CUST_ACCT.ATTRIBUTE7
, CUST_ACCT.ATTRIBUTE8
, CUST_ACCT.ATTRIBUTE9
, CUST_ACCT.ATTRIBUTE10
, CUST_ACCT.REQUEST_ID
, CUST_ACCT.PROGRAM_APPLICATION_ID
, CUST_ACCT.PROGRAM_ID
, CUST_ACCT.PROGRAM_UPDATE_DATE
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ANALYSIS_FY
, NULL)
, PARTY.CATEGORY_CODE
, NULL /* CUSTOMER_GROUP_CODE (NO LONGER USED) */
, PARTY.CUSTOMER_KEY
, NULL /* CUSTOMER_SUBGROUP_CODE (NO LONGER USED) */
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.FISCAL_YEAREND_MONTH
, NULL)
, TO_NUMBER(NULL) /* NET_WORTH (NO LONGER USED) */
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.EMPLOYEES_TOTAL
, TO_NUMBER(NULL))
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.CURR_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL))
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.NEXT_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL))
, NULL
, PARTY.REFERENCE_USE_FLAG
, CUST_ACCT.TAX_CODE
, PARTY.TAX_REFERENCE
, CUST_ACCT.ATTRIBUTE11
, CUST_ACCT.ATTRIBUTE12
, CUST_ACCT.ATTRIBUTE13
, CUST_ACCT.ATTRIBUTE14
, CUST_ACCT.ATTRIBUTE15
, PARTY.THIRD_PARTY_FLAG
, NULL /* ACCESS_TEMPLATE_ENTITY_CODE */
, CUST_ACCT.PRIMARY_SPECIALIST_ID
, CUST_ACCT.SECONDARY_SPECIALIST_ID
, PARTY.COMPETITOR_FLAG
, TO_NUMBER(NULL) /* DUNNING_SITE_USE_ID */
, TO_NUMBER(NULL) /* STATEMENT_SITE_USE_ID */
, NULL /* ORIG_SYSTEM */
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.YEAR_ESTABLISHED
, TO_NUMBER(NULL))
, CUST_ACCT.COTERMINATE_DAY_MONTH
, CUST_ACCT.FOB_POINT
, CUST_ACCT.FREIGHT_TERM
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.GSA_INDICATOR_FLAG
, 'N')
, CUST_ACCT.SHIP_PARTIAL
, CUST_ACCT.SHIP_VIA
, CUST_ACCT.WAREHOUSE_ID
, CUST_ACCT.PAYMENT_TERM_ID
, NULL /* TAX_EXEMPT (NO LONGER USED) */
, NULL /* TAX_EXEMPT_NUM (NO LONGER USED) */
, NULL /* TAX_EXEMPT_REASON_CODE (NO LONGER USED) */
, PARTY.JGZZ_FISCAL_CODE
, PARTY.DO_NOT_MAIL_FLAG /* DO_NOT_MAIL_FLAG */
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.MISSION_STATEMENT
, NULL)
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, NULL) /* CUSTOMER_NAME_PHONETIC */
, CUST_ACCT.TAX_HEADER_LEVEL_FLAG
, CUST_ACCT.TAX_ROUNDING_RULE
, CUST_ACCT.WH_UPDATE_DATE
, CUST_ACCT.GLOBAL_ATTRIBUTE1
, CUST_ACCT.GLOBAL_ATTRIBUTE2
, CUST_ACCT.GLOBAL_ATTRIBUTE3
, CUST_ACCT.GLOBAL_ATTRIBUTE4
, CUST_ACCT.GLOBAL_ATTRIBUTE5
, CUST_ACCT.GLOBAL_ATTRIBUTE6
, CUST_ACCT.GLOBAL_ATTRIBUTE7
, CUST_ACCT.GLOBAL_ATTRIBUTE8
, CUST_ACCT.GLOBAL_ATTRIBUTE9
, CUST_ACCT.GLOBAL_ATTRIBUTE10
, CUST_ACCT.GLOBAL_ATTRIBUTE11
, CUST_ACCT.GLOBAL_ATTRIBUTE12
, CUST_ACCT.GLOBAL_ATTRIBUTE13
, CUST_ACCT.GLOBAL_ATTRIBUTE14
, CUST_ACCT.GLOBAL_ATTRIBUTE15
, CUST_ACCT.GLOBAL_ATTRIBUTE16
, CUST_ACCT.GLOBAL_ATTRIBUTE17
, CUST_ACCT.GLOBAL_ATTRIBUTE18
, CUST_ACCT.GLOBAL_ATTRIBUTE19
, CUST_ACCT.GLOBAL_ATTRIBUTE20
, CUST_ACCT.GLOBAL_ATTRIBUTE_CATEGORY
, PARTY.URL
, NULL /* LANGUAGE */
, NULL /* TRANSLATED_CUSTOMER_NAME */
, PARTY.PERSON_PRE_NAME_ADJUNCT /* PREFIX */
, PARTY.PERSON_FIRST_NAME
, PARTY.PERSON_MIDDLE_NAME
, PARTY.PERSON_LAST_NAME
, PARTY.PERSON_NAME_SUFFIX
, DECODE(PARTY.PARTY_TYPE
, 'PERSON'
, PARTY.PERSON_FIRST_NAME_PHONETIC
, NULL)
, DECODE(PARTY.PARTY_TYPE
, 'PERSON'
, PARTY.PERSON_LAST_NAME_PHONETIC
, NULL)
, CUST_ACCT.SHIP_SETS_INCLUDE_LINES_FLAG
, CUST_ACCT.ARRIVALSETS_INCLUDE_LINES_FLAG
, CUST_ACCT.SCHED_DATE_PUSH_FLAG
, CUST_ACCT.OVER_SHIPMENT_TOLERANCE
, CUST_ACCT.UNDER_SHIPMENT_TOLERANCE
, CUST_ACCT.OVER_RETURN_TOLERANCE
, CUST_ACCT.UNDER_RETURN_TOLERANCE
, CUST_ACCT.ITEM_CROSS_REF_PREF
, CUST_ACCT.DATE_TYPE_PREFERENCE
, CUST_ACCT.DATES_NEGATIVE_TOLERANCE
, CUST_ACCT.DATES_POSITIVE_TOLERANCE
, CUST_ACCT.INVOICE_QUANTITY_RULE
, CUST_ACCT.ATTRIBUTE16
, CUST_ACCT.ATTRIBUTE17
, CUST_ACCT.ATTRIBUTE18
, CUST_ACCT.ATTRIBUTE19
, CUST_ACCT.ATTRIBUTE20
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.DUNS_NUMBER
, NULL)
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.DUNS_NUMBER_C
, NULL)
, PARTY.LAST_UPDATE_DATE
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.SIC_CODE_TYPE
, NULL)
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID = PARTY.PARTY_ID

Columns