VIEW: APPS.AMS_ORG_FINANCIAL_RPT_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'