Product: | AMS - Marketing |
---|---|
Description: | Financial reports of parties |
Implementation/DBA Data: | APPS.AMS_ORG_FINANCIAL_RPT_V |
SELECT HFR.FINANCIAL_REPORT_ID
, HFR.DATE_REPORT_ISSUED
, HFR.PARTY_ID
, HFR.DOCUMENT_REFERENCE
, HFR.ISSUED_PERIOD
, HFR.REQUIRING_AUTHORITY
, HFR.TYPE_OF_FINANCIAL_REPORT
, HFR.REPORT_START_DATE
, HFR.REPORT_END_DATE
, HFR.AUDIT_IND
, HFR.CONSOLIDATED_IND
, HFR.ESTIMATED_IND
, HFR.FISCAL_IND
, HFR.FINAL_IND
, HFR.FORECAST_IND
, HFR.OPENING_IND
, HFR.PROFORMA_IND
, HFR.QUALIFIED_IND
, HFR.RESTATED_IND
, HFR.SIGNED_BY_PRINCIPALS_IND
, HFR.TRIAL_BALANCE_IND
, HFR.UNBALANCED_IND
, HFR.CONTENT_SOURCE_TYPE
, HFR.CREATED_BY
, HFR.CREATION_DATE
, HFR.LAST_UPDATE_LOGIN
, HFR.LAST_UPDATE_DATE
, HFR.LAST_UPDATED_BY
, HFR.REQUEST_ID
, HFR.PROGRAM_APPLICATION_ID
, HFR.PROGRAM_ID
, HFR.PROGRAM_UPDATE_DATE
, HFR.WH_UDPATE_ID
, HFR.CREATED_BY CREATED_BY_NAME
, HFR.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN_NAME
, HFR.LAST_UPDATED_BY LAST_UPDATED_BY_NAME
FROM HZ_FINANCIAL_REPORTS HFR
, HZ_PARTIES HP
WHERE HFR.PARTY_ID = HP.PARTY_ID
AND HP.STATUS = 'A'
AND HFR.ACTUAL_CONTENT_SOURCE = 'USER_ENTERED'
AND HP.PARTY_TYPE = 'ORGANIZATION'