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

VIEW: FV.FV_SF224_AUDITS#

Object Details
Object Name: FV_SF224_AUDITS#
Object Type: VIEW
Owner: FV
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (15) Yes
SF224_MONTH_REPORTED VARCHAR2 (25) Yes
REPORTED_MONTH VARCHAR2 (25) Yes
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_LOGIN NUMBER (15) Yes
COLUMN_GROUP VARCHAR2 (2)
TREASURY_SYMBOL VARCHAR2 (35)
EXCEPTION_CATEGORY VARCHAR2 (25)
GL_PERIOD VARCHAR2 (25)
SUPPLEMENTAL_FLAG VARCHAR2 (1)
REPORTED_GL_PERIOD VARCHAR2 (25)
SET_OF_BOOKS_ID NUMBER (15)
ALC_CODE VARCHAR2 (30)
ORG_ID NUMBER (15)
JE_HEADER_ID NUMBER (15)
JE_LINE_NUM NUMBER (15)
PROCESS_ID NUMBER (15)
TREASURY_SYMBOL_ID NUMBER (15) Yes
INTER_AGENCY_FLAG VARCHAR2 (1)
RECORD_TYPE VARCHAR2 (30)
JE_SOURCE VARCHAR2 (25)
JE_CATEGORY VARCHAR2 (25)
DOCUMENT_NUMBER VARCHAR2 (50)
JE_FROM_SLA_FLAG VARCHAR2 (1)
Query Text

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


SELECT BATCH_ID
,      SF224_MONTH_REPORTED
,      REPORTED_MONTH
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      COLUMN_GROUP
,      TREASURY_SYMBOL
,      EXCEPTION_CATEGORY
,      GL_PERIOD
,      SUPPLEMENTAL_FLAG
,      REPORTED_GL_PERIOD
,      SET_OF_BOOKS_ID
,      ALC_CODE
,      ORG_ID
,      JE_HEADER_ID
,      JE_LINE_NUM
,      PROCESS_ID
,      TREASURY_SYMBOL_ID
,      INTER_AGENCY_FLAG
,      RECORD_TYPE
,      JE_SOURCE
,      JE_CATEGORY
,      DOCUMENT_NUMBER
,      JE_FROM_SLA_FLAG
FROM FV.FV_SF224_AUDITS#;

Dependencies

[top of page]

FV.FV_SF224_AUDITS# references the following:

SchemaFV
TableFV_SF224_AUDITS
FV.FV_SF224_AUDITS# is referenced by following:

SchemaAPPS
SynonymFV_SF224_AUDITS