VIEW: APPS.UMX_ORGANIZATION_PVT_V

Source

View Text - Preformatted

SELECT PARTY_ID, PARTY_NAME, PARTY_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, WH_UPDATE_DATE, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE, KNOWN_AS, TAX_NAME, TAX_REFERENCE, JGZZ_FISCAL_CODE, KNOWN_AS2, KNOWN_AS3, KNOWN_AS4, KNOWN_AS5, STATUS, OBJECT_VERSION_NUMBER, CREATED_BY_MODULE, ORIG_SYSTEM_REFERENCE, APPLICATION_ID, COUNTRY, ADDRESS1, ADDRESS2, ADDRESS3, ADDRESS4, CITY, POSTAL_CODE, STATE, PROVINCE, COUNTY, EMAIL_ADDRESS, ORGANIZATION_NAME_PHONETIC, LANGUAGE_NAME, CATEGORY_CODE, ANALYSIS_FY, FISCAL_YEAREND_MONTH, EMPLOYEES_TOTAL, CURR_FY_POTENTIAL_REVENUE, NEXT_FY_POTENTIAL_REVENUE, YEAR_ESTABLISHED, GSA_INDICATOR_FLAG, MISSION_STATEMENT, DUNS_NUMBER, COMPETITOR_FLAG, THIRD_PARTY_FLAG, REFERENCE_USE_FLAG, SIC_CODE_TYPE from HZ_PARTIES WHERE PARTY_TYPE = 'ORGANIZATION'
   

View Text - HTML Formatted

SELECT PARTY_ID
, PARTY_NAME
, PARTY_NUMBER
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, WH_UPDATE_DATE
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
, KNOWN_AS
, TAX_NAME
, TAX_REFERENCE
, JGZZ_FISCAL_CODE
, KNOWN_AS2
, KNOWN_AS3
, KNOWN_AS4
, KNOWN_AS5
, STATUS
, OBJECT_VERSION_NUMBER
, CREATED_BY_MODULE
, ORIG_SYSTEM_REFERENCE
, APPLICATION_ID
, COUNTRY
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, CITY
, POSTAL_CODE
, STATE
, PROVINCE
, COUNTY
, EMAIL_ADDRESS
, ORGANIZATION_NAME_PHONETIC
, LANGUAGE_NAME
, CATEGORY_CODE
, ANALYSIS_FY
, FISCAL_YEAREND_MONTH
, EMPLOYEES_TOTAL
, CURR_FY_POTENTIAL_REVENUE
, NEXT_FY_POTENTIAL_REVENUE
, YEAR_ESTABLISHED
, GSA_INDICATOR_FLAG
, MISSION_STATEMENT
, DUNS_NUMBER
, COMPETITOR_FLAG
, THIRD_PARTY_FLAG
, REFERENCE_USE_FLAG
, SIC_CODE_TYPE
FROM HZ_PARTIES
WHERE PARTY_TYPE = 'ORGANIZATION'