DBA Data[Home] [Help] [Dependency Information]


VIEW: AR.HZ_FINANCIAL_REPORTS#

Object Details
Object Name: HZ_FINANCIAL_REPORTS#
Object Type: VIEW
Owner: AR
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
FINANCIAL_REPORT_ID NUMBER (15) Yes
DATE_REPORT_ISSUED DATE

PARTY_ID NUMBER (15) Yes
DOCUMENT_REFERENCE VARCHAR2 (150)
ISSUED_PERIOD VARCHAR2 (60)
REQUIRING_AUTHORITY VARCHAR2 (60)
TYPE_OF_FINANCIAL_REPORT VARCHAR2 (60)
REPORT_START_DATE DATE

REPORT_END_DATE DATE

AUDIT_IND VARCHAR2 (30)
CONSOLIDATED_IND VARCHAR2 (30)
ESTIMATED_IND VARCHAR2 (30)
FISCAL_IND VARCHAR2 (30)
FINAL_IND VARCHAR2 (30)
FORECAST_IND VARCHAR2 (30)
OPENING_IND VARCHAR2 (30)
PROFORMA_IND VARCHAR2 (30)
QUALIFIED_IND VARCHAR2 (30)
RESTATED_IND VARCHAR2 (30)
SIGNED_BY_PRINCIPALS_IND VARCHAR2 (30)
TRIAL_BALANCE_IND VARCHAR2 (30)
UNBALANCED_IND VARCHAR2 (30)
CONTENT_SOURCE_TYPE VARCHAR2 (30) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

WH_UDPATE_ID DATE

STATUS VARCHAR2 (1)
OBJECT_VERSION_NUMBER NUMBER

CREATED_BY_MODULE VARCHAR2 (150)
APPLICATION_ID NUMBER

ACTUAL_CONTENT_SOURCE VARCHAR2 (30) Yes
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT FINANCIAL_REPORT_ID
,      DATE_REPORT_ISSUED
,      PARTY_ID
,      DOCUMENT_REFERENCE
,      ISSUED_PERIOD
,      REQUIRING_AUTHORITY
,      TYPE_OF_FINANCIAL_REPORT
,      REPORT_START_DATE
,      REPORT_END_DATE
,      AUDIT_IND
,      CONSOLIDATED_IND
,      ESTIMATED_IND
,      FISCAL_IND
,      FINAL_IND
,      FORECAST_IND
,      OPENING_IND
,      PROFORMA_IND
,      QUALIFIED_IND
,      RESTATED_IND
,      SIGNED_BY_PRINCIPALS_IND
,      TRIAL_BALANCE_IND
,      UNBALANCED_IND
,      CONTENT_SOURCE_TYPE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_LOGIN
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
,      WH_UDPATE_ID
,      STATUS
,      OBJECT_VERSION_NUMBER
,      CREATED_BY_MODULE
,      APPLICATION_ID
,      ACTUAL_CONTENT_SOURCE
FROM AR.HZ_FINANCIAL_REPORTS#;

Dependencies

[top of page]

AR.HZ_FINANCIAL_REPORTS# references the following:

SchemaAR
TableHZ_FINANCIAL_REPORTS
AR.HZ_FINANCIAL_REPORTS# is referenced by following:

SchemaAPPS
SynonymHZ_FINANCIAL_REPORTS