VIEW: APPS.CSC_HZ_ORG_PROFILES_V

Source

View Text - Preformatted

SELECT ORG_PROFILE.PARTY_ID , PARTY.SIC_CODE , PARTY.KNOWN_AS , PARTY.PARTY_NAME , ORG_PROFILE.ANALYSIS_FY , ORG_PROFILE.FISCAL_YEAREND_MONTH , ORG_PROFILE.EMPLOYEES_TOTAL , ORG_PROFILE.CURR_FY_POTENTIAL_REVENUE , ORG_PROFILE.NEXT_FY_POTENTIAL_REVENUE , ORG_PROFILE.TAX_REFERENCE , ORG_PROFILE.YEAR_ESTABLISHED , ORG_PROFILE.INTERNAL_FLAG , ORG_PROFILE.PUBLIC_PRIVATE_OWNERSHIP_FLAG , ORG_PROFILE.DUNS_NUMBER , ORG_PROFILE.JGZZ_FISCAL_CODE , ORG_PROFILE.LAST_UPDATE_DATE , ORG_PROFILE.LINE_OF_BUSINESS , PARTY.CATEGORY_CODE ,ORG_PROFILE.DUNS_NUMBER_C FROM HZ_ORGANIZATION_PROFILES ORG_PROFILE, HZ_PARTIES PARTY WHERE PARTY.PARTY_ID = ORG_PROFILE.PARTY_ID AND PARTY.PARTY_TYPE = 'ORGANIZATION' AND (ORG_PROFILE.EFFECTIVE_END_DATE IS NULL OR SYSDATE BETWEEN ORG_PROFILE.EFFECTIVE_START_DATE AND ORG_PROFILE.EFFECTIVE_END_DATE)

View Text - HTML Formatted

SELECT ORG_PROFILE.PARTY_ID
, PARTY.SIC_CODE
, PARTY.KNOWN_AS
, PARTY.PARTY_NAME
, ORG_PROFILE.ANALYSIS_FY
, ORG_PROFILE.FISCAL_YEAREND_MONTH
, ORG_PROFILE.EMPLOYEES_TOTAL
, ORG_PROFILE.CURR_FY_POTENTIAL_REVENUE
, ORG_PROFILE.NEXT_FY_POTENTIAL_REVENUE
, ORG_PROFILE.TAX_REFERENCE
, ORG_PROFILE.YEAR_ESTABLISHED
, ORG_PROFILE.INTERNAL_FLAG
, ORG_PROFILE.PUBLIC_PRIVATE_OWNERSHIP_FLAG
, ORG_PROFILE.DUNS_NUMBER
, ORG_PROFILE.JGZZ_FISCAL_CODE
, ORG_PROFILE.LAST_UPDATE_DATE
, ORG_PROFILE.LINE_OF_BUSINESS
, PARTY.CATEGORY_CODE
, ORG_PROFILE.DUNS_NUMBER_C
FROM HZ_ORGANIZATION_PROFILES ORG_PROFILE
, HZ_PARTIES PARTY
WHERE PARTY.PARTY_ID = ORG_PROFILE.PARTY_ID
AND PARTY.PARTY_TYPE = 'ORGANIZATION'
AND (ORG_PROFILE.EFFECTIVE_END_DATE IS NULL OR SYSDATE BETWEEN ORG_PROFILE.EFFECTIVE_START_DATE
AND ORG_PROFILE.EFFECTIVE_END_DATE)