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.

[Home] [Help]

View: ASF_ORGANIZATIONS_QF_V

Product:	ASF - Sales Online
Description:	View for Organization Quick Find
Implementation/DBA Data:	APPS.ASF_ORGANIZATIONS_QF_V

View Text

SELECT ORG.PARTY_ID
, ORG.PARTY_ID
, ORG.PARTY_NAME
, ORG.PARTY_NUMBER
, ORG.TAX_REFERENCE
, ORG.STATUS
, ORG.SIC_CODE
, ORG.CATEGORY_CODE
, ORG.URL
, ORG.ADDRESS1|| DECODE(ORG.ADDRESS2
, NULL
, ''
, ' '||ORG.ADDRESS2)|| DECODE(ORG.ADDRESS3
, NULL
, ''
, ' '||ORG.ADDRESS3)|| DECODE(ORG.ADDRESS4
, NULL
, ''
, ' '||ORG.ADDRESS4)|| '
, '||ORG.CITY||'
, '|| ORG.STATE||'
, '||ORG.POSTAL_CODE||'
, '||ORG.COUNTRY
, ORG.ADDRESS1|| DECODE(ORG.ADDRESS2
, NULL
, ''
, ' '||ORG.ADDRESS2)|| DECODE(ORG.ADDRESS3
, NULL
, ''
, ' '||ORG.ADDRESS3)|| DECODE(ORG.ADDRESS4
, NULL
, ''
, ' '||ORG.ADDRESS4)
, ORG.ADDRESS1
, ORG.ADDRESS2
, ORG.ADDRESS3
, ORG.ADDRESS4
, ORG.STATE
, ORG.CITY
, ORG.PROVINCE
, ORG.COUNTY
, ORG.POSTAL_CODE
, ORG.COUNTRY
, ORG.KNOWN_AS
, ORG.YEAR_ESTABLISHED
, ORG.EMAIL_ADDRESS
, ORG.FISCAL_YEAREND_MONTH
, ORG.LAST_ORDERED_DATE
, ORG.CREATION_DATE
, ORG.LAST_UPDATE_DATE
, ORG.CREATED_BY
, ORG.LAST_UPDATED_BY
FROM HZ_PARTIES ORG
WHERE ORG.PARTY_TYPE = 'ORGANIZATION'
AND ORG.STATUS IN ('A'
, 'I')

Columns

Name
ORG_ID
PARTY_ID
ORG_NAME
ORG_NUMBER
TAX_REFERENCE
STATUS_CODE
SIC_CODE
CATEGORY_CODE
URL
ADDRESS_BOOK
ADDRESS
ADDRESS1
ADDRESS2
ADDRESS3
ADDRESS4
STATE
CITY
PROVINCE
COUNTY
POSTAL_CODE
COUNTRY
ALIAS
YEAR_ESTABLISHED
EMAIL
FISCAL_YEAREND_MONTH
LAST_ORDER_DATE
CREATION_DATE
LAST_UPDATE_DATE
CREATED_BY
LAST_UPDATED_BY