eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.OE_RA_CUSTOMERS_V

Source

View Text - Preformatted


SELECT CUST_ACCT.CUST_ACCOUNT_ID, 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*/, PARTY.CUSTOMER_KEY , NULL /*CUSTOMER_SUBGROUP_CODE*/ , DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.FISCAL_YEAREND_MONTH ,NULL), TO_NUMBER(NULL) /*NET_WORTH*/ , 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 /*RANK*/ , 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*/ , NULL /*TAX_EXEMPT_NUM*/ , NULL /*TAX_EXEMPT_REASON_CODE*/ , PARTY.JGZZ_FISCAL_CODE , PARTY.DO_NOT_MAIL_FLAG , DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.MISSION_STATEMENT ,NULL), DECODE(PARTY.PARTY_TYPE,'ORGANIZATION',PARTY.ORGANIZATION_NAME_PHONETIC ,NULL), 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 FROM HZ_PARTIES PARTY, HZ_CUST_ACCOUNTS CUST_ACCT WHERE CUST_ACCT.PARTY_ID=PARTY.PARTY_ID

View Text - HTML Formatted

SELECT CUST_ACCT.CUST_ACCOUNT_ID
, 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*/
, PARTY.CUSTOMER_KEY
, NULL /*CUSTOMER_SUBGROUP_CODE*/
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.FISCAL_YEAREND_MONTH
, NULL)
, TO_NUMBER(NULL) /*NET_WORTH*/
, 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 /*RANK*/
, 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*/
, NULL /*TAX_EXEMPT_NUM*/
, NULL /*TAX_EXEMPT_REASON_CODE*/
, PARTY.JGZZ_FISCAL_CODE
, PARTY.DO_NOT_MAIL_FLAG
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.MISSION_STATEMENT
, NULL)
, DECODE(PARTY.PARTY_TYPE
, 'ORGANIZATION'
, PARTY.ORGANIZATION_NAME_PHONETIC
, NULL)
, 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
FROM HZ_PARTIES PARTY
, HZ_CUST_ACCOUNTS CUST_ACCT
WHERE CUST_ACCT.PARTY_ID=PARTY.PARTY_ID