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

VIEW: APPS.IGSBV_USEC_OCCUR_REFERENCES

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

View Type

A Business Intelligence System view


Base View for Unit Section Occurrence Reference


[View Source]

Columns
Name Datatype Length Mandatory Comments
REFERENCE_CODE_TYPE VARCHAR2 (10) Yes Reference code type for the unit section occurrence
REFERENCE_CODE VARCHAR2 (30) Yes Reference code for the unit section occurrence.
REFERENCE_CODE_DESCRIPTION VARCHAR2 (60)
Description of the reference code.
UNIT_SEC_OCCUR_REFERENCE_ID NUMBER (10) Yes Unique identifier for the occurrences of a unit section reference.
UNIT_SECTION_OCCURRENCE_ID NUMBER (10) Yes Unique identifier for the occurrences of a unit section.
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 REFERENCE_CODE_TYPE
,      REFERENCE_CODE
,      REFERENCE_CODE_DESCRIPTION
,      UNIT_SEC_OCCUR_REFERENCE_ID
,      UNIT_SECTION_OCCURRENCE_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_USEC_OCCUR_REFERENCES;

Dependencies

[top of page]

APPS.IGSBV_USEC_OCCUR_REFERENCES references the following:

SchemaAPPS
SynonymIGS_PS_USEC_OCUR_REF

APPS.IGSBV_USEC_OCCUR_REFERENCES is not referenced by any database object