VIEW: APPS.AMS_ORG_FINANCIAL_NUMS_V

Source

View Text - Preformatted

SELECT hfn.FINANCIAL_NUMBER_ID ,hfn.FINANCIAL_REPORT_ID ,hfn.FINANCIAL_NUMBER ,hfn.FINANCIAL_NUMBER_NAME ,hfn.FINANCIAL_UNITS_APPLIED ,hfn.FINANCIAL_NUMBER_CURRENCY ,hfn.PROJECTED_ACTUAL_FLAG ,hfn.CREATED_BY ,hfn.CREATION_DATE ,hfn.LAST_UPDATE_LOGIN ,hfn.LAST_UPDATE_DATE ,hfn.LAST_UPDATED_BY ,hfn.REQUEST_ID ,hfn.PROGRAM_APPLICATION_ID ,hfn.PROGRAM_ID ,hfn.PROGRAM_UPDATE_DATE ,hfn.WH_UPDATE_DATE ,hfn.CONTENT_SOURCE_TYPE ,hfn.created_by CREATED_BY_NAME ,hfn.last_update_login LAST_UPDATE_LOGIN_NAME ,hfn.last_updated_by LAST_UPDATED_BY_NAME FROM HZ_FINANCIAL_NUMBERS hfn, HZ_FINANCIAL_REPORTS hfr, HZ_PARTIES hp WHERE hfn.FINANCIAL_REPORT_ID = hfr.FINANCIAL_REPORT_ID AND hfr.PARTY_ID = hp.PARTY_ID AND hp.STATUS = 'A' AND Hfn.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED' AND hp.PARTY_TYPE = 'ORGANIZATION'

View Text - HTML Formatted

SELECT HFN.FINANCIAL_NUMBER_ID
, HFN.FINANCIAL_REPORT_ID
, HFN.FINANCIAL_NUMBER
, HFN.FINANCIAL_NUMBER_NAME
, HFN.FINANCIAL_UNITS_APPLIED
, HFN.FINANCIAL_NUMBER_CURRENCY
, HFN.PROJECTED_ACTUAL_FLAG
, HFN.CREATED_BY
, HFN.CREATION_DATE
, HFN.LAST_UPDATE_LOGIN
, HFN.LAST_UPDATE_DATE
, HFN.LAST_UPDATED_BY
, HFN.REQUEST_ID
, HFN.PROGRAM_APPLICATION_ID
, HFN.PROGRAM_ID
, HFN.PROGRAM_UPDATE_DATE
, HFN.WH_UPDATE_DATE
, HFN.CONTENT_SOURCE_TYPE
, HFN.CREATED_BY CREATED_BY_NAME
, HFN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, HFN.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM HZ_FINANCIAL_NUMBERS HFN
, HZ_FINANCIAL_REPORTS HFR
, HZ_PARTIES HP
WHERE HFN.FINANCIAL_REPORT_ID = HFR.FINANCIAL_REPORT_ID
AND HFR.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HFN.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED'
AND HP.PARTY_TYPE = 'ORGANIZATION'