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


VIEW: APPS.IGS_GR_AWD_CRMN_V

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

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major
releases.

[View Source]

Columns
Name Datatype Length Mandatory Comments
GAC_ID NUMBER (9) Yes
PERSON_ID NUMBER (15) Yes
PERSON_NUMBER VARCHAR2 (30) Yes
BIRTH_DT DATE

ENCUMBERED_IND VARCHAR2 (4000)
DECEASED_IND VARCHAR2 (1)
CONTEXT_BLOCK_NAME VARCHAR2 (455)
SEX VARCHAR2 (30)
MEANING VARCHAR2 (80)
CREATE_DT DATE
Yes
GRD_CAL_TYPE VARCHAR2 (10) Yes
GRD_CI_SEQUENCE_NUMBER NUMBER (6) Yes
CEREMONY_NUMBER NUMBER (3) Yes
AWARD_COURSE_CD VARCHAR2 (6)
AWARD_CRS_VERSION_NUMBER NUMBER (3)
AWARD_CD VARCHAR2 (10) Yes
US_GROUP_NUMBER NUMBER (6)
ORDER_IN_PRESENTATION NUMBER (4)
GRADUAND_SEAT_NUMBER VARCHAR2 (10)
NAME_PRONUNCIATION VARCHAR2 (60)
NAME_ANNOUNCED VARCHAR2 (80)
ACADEMIC_DRESS_RQRD_IND VARCHAR2 (1) Yes
ACADEMIC_GOWN_SIZE VARCHAR2 (10)
ACADEMIC_HAT_SIZE VARCHAR2 (10)
GUEST_TICKETS_REQUESTED NUMBER (3)
GUEST_TICKETS_ALLOCATED NUMBER (3)
GUEST_SEATS VARCHAR2 (60)
FEES_PAID_IND VARCHAR2 (1) Yes
SPECIAL_REQUIREMENTS VARCHAR2 (2000)
COMMENTS VARCHAR2 (2000)
CREATED_BY NUMBER (15) Yes
CREATION_DATE DATE
Yes
LAST_UPDATED_BY NUMBER (15) Yes
LAST_UPDATE_DATE DATE
Yes
LAST_UPDATE_LOGIN NUMBER (15)
REQUEST_ID NUMBER (15)
PROGRAM_APPLICATION_ID NUMBER (15)
PROGRAM_ID NUMBER (15)
PROGRAM_UPDATE_DATE DATE

Query Text

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


SELECT GAC_ID
,      PERSON_ID
,      PERSON_NUMBER
,      BIRTH_DT
,      ENCUMBERED_IND
,      DECEASED_IND
,      CONTEXT_BLOCK_NAME
,      SEX
,      MEANING
,      CREATE_DT
,      GRD_CAL_TYPE
,      GRD_CI_SEQUENCE_NUMBER
,      CEREMONY_NUMBER
,      AWARD_COURSE_CD
,      AWARD_CRS_VERSION_NUMBER
,      AWARD_CD
,      US_GROUP_NUMBER
,      ORDER_IN_PRESENTATION
,      GRADUAND_SEAT_NUMBER
,      NAME_PRONUNCIATION
,      NAME_ANNOUNCED
,      ACADEMIC_DRESS_RQRD_IND
,      ACADEMIC_GOWN_SIZE
,      ACADEMIC_HAT_SIZE
,      GUEST_TICKETS_REQUESTED
,      GUEST_TICKETS_ALLOCATED
,      GUEST_SEATS
,      FEES_PAID_IND
,      SPECIAL_REQUIREMENTS
,      COMMENTS
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      REQUEST_ID
,      PROGRAM_APPLICATION_ID
,      PROGRAM_ID
,      PROGRAM_UPDATE_DATE
FROM APPS.IGS_GR_AWD_CRMN_V;

Dependencies

[top of page]

APPS.IGS_GR_AWD_CRMN_V references the following:

SchemaAPPS
PL/SQL PackageIGS_EN_GEN_003 - show dependent code
PL/SQL PackageIGS_EN_GEN_007 - show dependent code
SynonymIGS_GR_AWD_CRMN
ViewIGS_PE_PERSON_V

APPS.IGS_GR_AWD_CRMN_V is not referenced by any database object