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

VIEW: APPS.IGSBV_INTM_RETURN_CONDS

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

View Type

A Business Intelligence System view


Student Intermission Return Conditions


[View Source]

Columns
Name Datatype Length Mandatory Comments
PERSON_ID NUMBER (15) Yes Person Identifier
PROGRAM_CODE VARCHAR2 (6) Yes Program Code
START_DATE DATE
Yes Start date of intermission record
LOGICAL_DELETE_DATE DATE
Yes Logical delete date
RETURN_CONDITION VARCHAR2 (25) Yes Return Condition
STATUS_CODE VARCHAR2 (30) Yes Status Code
APPROVED_DATE DATE

Approved Date
APPROVED_BY NUMBER

Approved By
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
LAST_UPDATE_LOGIN NUMBER (15)
Standard WHO column
PERSON_NUMBER VARCHAR2 (30) Yes Person Number
PROGRAM_DESCRIPTION VARCHAR2 (90) Yes Program Description
RETURN_CONDITION_DESC VARCHAR2 (100) Yes Return Condition Description
Query Text

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


SELECT PERSON_ID
,      PROGRAM_CODE
,      START_DATE
,      LOGICAL_DELETE_DATE
,      RETURN_CONDITION
,      STATUS_CODE
,      APPROVED_DATE
,      APPROVED_BY
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      PERSON_NUMBER
,      PROGRAM_DESCRIPTION
,      RETURN_CONDITION_DESC
FROM APPS.IGSBV_INTM_RETURN_CONDS;

Dependencies

[top of page]

APPS.IGSBV_INTM_RETURN_CONDS references the following:

SchemaAPPS
SynonymHZ_PARTIES
SynonymIGS_EN_INTM_RCONDS
SynonymIGS_EN_SPI_RCONDS
SynonymIGS_EN_STDNT_PS_ATT_ALL
SynonymIGS_PS_VER_ALL

APPS.IGSBV_INTM_RETURN_CONDS is not referenced by any database object