VIEW: APPS.ASF_ORGANIZATIONS_QF_V

Source

View Text - Preformatted

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, ORG.CERTIFICATION_LEVEL FROM HZ_PARTIES ORG WHERE ORG.PARTY_TYPE = 'ORGANIZATION' AND ORG.STATUS IN ('A','I')

View Text - HTML Formatted

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
, ORG.CERTIFICATION_LEVEL
FROM HZ_PARTIES ORG
WHERE ORG.PARTY_TYPE = 'ORGANIZATION'
AND ORG.STATUS IN ('A'
, 'I')