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

VIEW: APPS.IGSBV_APPL_PANEL_DETAILS

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

View Type

A Business Intelligence System view


Base View for the Entity that holds the details about the application instan ces assigned to a panel


[View Source]

Columns
Name Datatype Length Mandatory Comments
PANEL_DETAILS_ID NUMBER
Yes Application Instance Panel ID. A unique identifier to identify each row in this table
PERSON_ID NUMBER (15) Yes Person Id
ADMISSION_APPL_NUMBER NUMBER (2)
Admission Application number
NOMINATED_PROGRAM_CODE VARCHAR2 (6)
Admission Application Course code
SEQUENCE_NUMBER NUMBER (6)
Admission Application Sequence number
PANEL_CODE VARCHAR2 (30) Yes Admission Panel Code
FINAL_DECISION_CODE VARCHAR2 (30) Yes Panel Final Decision
_LA:DECISION_TYPE_MEANING CHAR (74)
_LA:CLOSED_IND_FLAG CHAR (52)
INTERVIEW_DATE DATE

INTERVIEW_TIME DATE

LOCATION_CODE VARCHAR2 (10)
ROOM_ID NUMBER (15)
FINAL_DECISION_DATE DATE

_DF CHAR (34)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
Query Text

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


SELECT PANEL_DETAILS_ID
,      PERSON_ID
,      ADMISSION_APPL_NUMBER
,      NOMINATED_PROGRAM_CODE
,      SEQUENCE_NUMBER
,      PANEL_CODE
,      FINAL_DECISION_CODE
,      _LA:DECISION_TYPE_MEANING
,      _LA:CLOSED_IND_FLAG
,      INTERVIEW_DATE
,      INTERVIEW_TIME
,      LOCATION_CODE
,      ROOM_ID
,      FINAL_DECISION_DATE
,      _DF
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
FROM APPS.IGSBV_APPL_PANEL_DETAILS;

Dependencies

[top of page]

APPS.IGSBV_APPL_PANEL_DETAILS references the following:

SchemaAPPS
SynonymIGS_AD_PANEL_DTLS

APPS.IGSBV_APPL_PANEL_DETAILS is not referenced by any database object