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

VIEW: APPS.IGS_OR_INST_EXEMPT_V

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

View Type

A public view which may be useful for custom reporting or other data
requirements.


Valid values for advanced standing exemption institution, DETYA element 368


[View Source]

Columns
Name Datatype Length Mandatory Comments
TCA_PARTY_NUMBER VARCHAR2 (30)
Party Number of the Institution in HZ_PARTIES
EXEMPTION_INSTITUTION_CD VARCHAR2 (30)
Product recognized Institution Code
NAME VARCHAR2 (360)
Name of the exemption institution
INSTITUTION_STATUS VARCHAR2 (10)
Status that indicates the level of activity of the institution. Statuses are institution defined, and each maps to a system institution status, Active or Inactive that is recognized by the system for functionality.
SOURCE VARCHAR2 (16)
Source of exemption institution, Institution Code
CREATED_BY NUMBER

Standard Who column
CREATION_DATE DATE

Standard Who column
LAST_UPDATED_BY NUMBER

Standard Who column
LAST_UPDATE_DATE DATE

Standard Who column
LAST_UPDATE_LOGIN NUMBER

Standard Who column
Query Text

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


SELECT TCA_PARTY_NUMBER
,      EXEMPTION_INSTITUTION_CD
,      NAME
,      INSTITUTION_STATUS
,      SOURCE
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
FROM APPS.IGS_OR_INST_EXEMPT_V;

Dependencies

[top of page]

APPS.IGS_OR_INST_EXEMPT_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGS_LOOKUP_VALUES
SynonymIGS_PE_HZ_PARTIES
APPS.IGS_OR_INST_EXEMPT_V is referenced by following:

SchemaAPPS
Package BodyIGS_AV_LVL_LGCY_PUB - show dependent code
ViewIGS_EN_STDNT_PS_INTM_V