View: AR_CUSTOMERS

Product:	AR - Receivables
Description:	(Release 11.5 Only)
Implementation/DBA Data:	APPS.AR_CUSTOMERS

View Text

SELECT CUST.CUST_ACCOUNT_ID CUSTOMER_ID
, SUBSTRB(PARTY.PARTY_NAME
, 1
, 50) CUSTOMER_NAME
, CUST.ACCOUNT_NUMBER CUSTOMER_NUMBER
, PARTY.CUSTOMER_KEY CUSTOMER_KEY
, CUST.STATUS STATUS
, CUST.ORIG_SYSTEM_REFERENCE ORIG_SYSTEM_REFERENCE
, 'CUSTOMER' CUSTOMER_PROSPECT_CODE
, PARTY.CATEGORY_CODE CUSTOMER_CATEGORY_CODE
, CUST.CUSTOMER_CLASS_CODE CUSTOMER_CLASS_CODE
, CUST.CUSTOMER_TYPE CUSTOMER_TYPE
, CUST.PRIMARY_SALESREP_ID PRIMARY_SALESREP_ID
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.SIC_CODE
, NULL) SIC_CODE
, PARTY.TAX_REFERENCE TAX_REFERENCE
, CUST.TAX_CODE TAX_CODE
, CUST.FOB_POINT FOB_POINT
, CUST.SHIP_VIA SHIP_VIA
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.GSA_INDICATOR_FLAG
, 'N') GSA_INDICATOR
, CUST.SHIP_PARTIAL SHIP_PARTIAL
, PARTY.JGZZ_FISCAL_CODE TAXPAYER_ID
, CUST.PRICE_LIST_ID PRICE_LIST_ID
, CUST.FREIGHT_TERM FREIGHT_TERM
, CUST.ORDER_TYPE_ID ORDER_TYPE_ID
, CUST.SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, CUST.WAREHOUSE_ID WAREHOUSE_ID
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.MISSION_STATEMENT
, NULL) MISSION_STATEMENT
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.EMPLOYEES_TOTAL
, TO_NUMBER(NULL)) NUM_OF_EMPLOYEES
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.CURR_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL)) POTENTIAL_REVENUE_CURR_FY
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.NEXT_FY_POTENTIAL_REVENUE
, TO_NUMBER(NULL)) POTENTIAL_REVENUE_NEXT_FY
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.FISCAL_YEAREND_MONTH
, NULL) FISCAL_YEAREND_MONTH
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.YEAR_ESTABLISHED
, TO_NUMBER(NULL)) YEAR_ESTABLISHED
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ANALYSIS_FY
, NULL) ANALYSIS_FY
, PARTY.COMPETITOR_FLAG COMPETITOR_FLAG
, PARTY.REFERENCE_USE_FLAG REFERENCE_USE_FLAG
, PARTY.THIRD_PARTY_FLAG THIRD_PARTY_FLAG
, CUST.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, CUST.ATTRIBUTE1 ATTRIBUTE1
, CUST.ATTRIBUTE2 ATTRIBUTE2
, CUST.ATTRIBUTE3 ATTRIBUTE3
, CUST.ATTRIBUTE4 ATTRIBUTE4
, CUST.ATTRIBUTE5 ATTRIBUTE5
, CUST.ATTRIBUTE6 ATTRIBUTE6
, CUST.ATTRIBUTE7 ATTRIBUTE7
, CUST.ATTRIBUTE8 ATTRIBUTE8
, CUST.ATTRIBUTE9 ATTRIBUTE9
, CUST.ATTRIBUTE10 ATTRIBUTE10
, CUST.ATTRIBUTE11 ATTRIBUTE11
, CUST.ATTRIBUTE12 ATTRIBUTE12
, CUST.ATTRIBUTE13 ATTRIBUTE13
, CUST.ATTRIBUTE14 ATTRIBUTE14
, CUST.ATTRIBUTE15 ATTRIBUTE15
, CUST.LAST_UPDATED_BY LAST_UPDATED_BY
, CUST.LAST_UPDATE_DATE LAST_UPDATE_DATE
, CUST.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUST.CREATED_BY CREATED_BY
, CUST.CREATION_DATE CREATION_DATE
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, NULL) CUSTOMER_NAME_PHONETIC
, CUST.TAX_HEADER_LEVEL_FLAG TAX_HEADER_LEVEL_FLAG
, CUST.TAX_ROUNDING_RULE TAX_ROUNDING_RULE
, CUST.GLOBAL_ATTRIBUTE_CATEGORY GLOBAL_ATTRIBUTE_CATEGORY
, CUST.GLOBAL_ATTRIBUTE1 GLOBAL_ATTRIBUTE1
, CUST.GLOBAL_ATTRIBUTE2 GLOBAL_ATTRIBUTE2
, CUST.GLOBAL_ATTRIBUTE3 GLOBAL_ATTRIBUTE3
, CUST.GLOBAL_ATTRIBUTE4 GLOBAL_ATTRIBUTE4
, CUST.GLOBAL_ATTRIBUTE5 GLOBAL_ATTRIBUTE5
, CUST.GLOBAL_ATTRIBUTE6 GLOBAL_ATTRIBUTE6
, CUST.GLOBAL_ATTRIBUTE7 GLOBAL_ATTRIBUTE7
, CUST.GLOBAL_ATTRIBUTE8 GLOBAL_ATTRIBUTE8
, CUST.GLOBAL_ATTRIBUTE9 GLOBAL_ATTRIBUTE9
, CUST.GLOBAL_ATTRIBUTE10 GLOBAL_ATTRIBUTE10
, CUST.GLOBAL_ATTRIBUTE11 GLOBAL_ATTRIBUTE11
, CUST.GLOBAL_ATTRIBUTE12 GLOBAL_ATTRIBUTE12
, CUST.GLOBAL_ATTRIBUTE13 GLOBAL_ATTRIBUTE13
, CUST.GLOBAL_ATTRIBUTE14 GLOBAL_ATTRIBUTE14
, CUST.GLOBAL_ATTRIBUTE15 GLOBAL_ATTRIBUTE15
, CUST.GLOBAL_ATTRIBUTE16 GLOBAL_ATTRIBUTE16
, CUST.GLOBAL_ATTRIBUTE17 GLOBAL_ATTRIBUTE17
, CUST.GLOBAL_ATTRIBUTE18 GLOBAL_ATTRIBUTE18
, CUST.GLOBAL_ATTRIBUTE19 GLOBAL_ATTRIBUTE19
, CUST.GLOBAL_ATTRIBUTE20 GLOBAL_ATTRIBUTE20
FROM HZ_CUST_ACCOUNTS CUST
, HZ_PARTIES PARTY
WHERE CUST.PARTY_ID = PARTY.PARTY_ID

Columns