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

VIEW: APPS.IGSBV_HIGH_EDU_PRG_REFERENCES

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

View Type

A Business Intelligence System view


This is a base view, which describes a reference code or codes that relates to the program.


[View Source]

Columns
Name Datatype Length Mandatory Comments
PROGRAM_CODE VARCHAR2 (6) Yes Unique identifier of a program for which the reference code is being specified.
PROGRAM_VERSION_NUMBER NUMBER (3) Yes Version number of a program for which the reference code is being specified.
REFERENCE_CODE_TYPE VARCHAR2 (10) Yes Type or classification of another system's reference code for a program.
REFERENCE_CODE VARCHAR2 (30) Yes Other system's reference code for a program.
REFERENCE_CODE_DESCRIPTION VARCHAR2 (60)
Description of the reference code specified for a program.
PROGRAM_TITLE VARCHAR2 (90) Yes Description of the program for which the reference code is being specified.
REFERENCE_CODE_TYPE_DESC VARCHAR2 (60) Yes Description of the reference code type.
CREATED_BY NUMBER (15) Yes Standard Who column
CREATION_DATE DATE
Yes Standard Who column
LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
LAST_UPDATE_DATE DATE
Yes Standard Who column
Query Text

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


SELECT PROGRAM_CODE
,      PROGRAM_VERSION_NUMBER
,      REFERENCE_CODE_TYPE
,      REFERENCE_CODE
,      REFERENCE_CODE_DESCRIPTION
,      PROGRAM_TITLE
,      REFERENCE_CODE_TYPE_DESC
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_HIGH_EDU_PRG_REFERENCES;

Dependencies

[top of page]

APPS.IGSBV_HIGH_EDU_PRG_REFERENCES references the following:

SchemaAPPS
SynonymIGS_GE_REF_CD_TYPE_ALL
SynonymIGS_PS_REF_CD
SynonymIGS_PS_VER_ALL

APPS.IGSBV_HIGH_EDU_PRG_REFERENCES is not referenced by any database object