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

VIEW: APPS.IGSBV_HESA_EXT_RUN_DAT_FIELDS

Object Details
Object Name: IGSBV_HESA_EXT_RUN_DAT_FIELDS
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGS.IGSBV_HESA_EXT_RUN_DAT_FIELDS
Subobject Name:
Status: VALID

View Type

A Business Intelligence System view


Base View for HESA extract data fields


[View Source]

Columns
Name Datatype Length Mandatory Comments
HESA_RETURN_FIELD_ID NUMBER
Yes Sequence number uniquely identifying the HESA return line field
EXTRACT_RUN_ID NUMBER
Yes Unique identifier for the HESA extract
LINE_NUMBER NUMBER
Yes Unique identifier for each line in the Extract file
FIELD_NUMBER NUMBER
Yes HESA field number
VALUE VARCHAR2 (100)
Derived value
OVERRIDE_VALUE VARCHAR2 (100)
Manual override value
CREATED_BY NUMBER (15) Yes Standard WHO column indicates who created this record
CREATION_DATE DATE
Yes Standard WHO column indicates when this record was created
LAST_UPDATED_BY NUMBER (15) Yes Standard WHO column indicates who updated this record last
LAST_UPDATE_DATE DATE
Yes Standard WHO column indicates when this record was last updated
Query Text

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


SELECT HESA_RETURN_FIELD_ID
,      EXTRACT_RUN_ID
,      LINE_NUMBER
,      FIELD_NUMBER
,      VALUE
,      OVERRIDE_VALUE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_HESA_EXT_RUN_DAT_FIELDS;

Dependencies

[top of page]

APPS.IGSBV_HESA_EXT_RUN_DAT_FIELDS references the following:

SchemaAPPS
SynonymIGS_HE_EX_RN_DAT_FD

APPS.IGSBV_HESA_EXT_RUN_DAT_FIELDS is not referenced by any database object