Product: | AMS - Marketing |
---|---|
Description: | Details of financial reports |
Implementation/DBA Data: | APPS.AMS_ORG_FINANCIAL_NUMS_V |
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'