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

VIEW: APPS.IGF_SL_LOCAL_INST_V

Object Details
Object Name: IGF_SL_LOCAL_INST_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewIGF.IGF_SL_LOCAL_INST_V
Subobject Name:
Status: VALID

View Type

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


Displays the Local School Name, Address details.


[View Source]

Columns
Name Datatype Length Mandatory Comments
SCHOOL_NAME VARCHAR2 (360) Yes School Name
ADDR_USE_TYPE VARCHAR2 (30)
Site use type
ADDR_LINE_1 VARCHAR2 (240)
First line of address
ADDR_LINE_2 VARCHAR2 (240)
Second line of address
ADDR_LINE_3 VARCHAR2 (240)
Third line of address
ADDR_LINE_4 VARCHAR2 (240)
Forth line of addres
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60)
Country
POSTAL_CODE VARCHAR2 (60)
Postal Code
Query Text

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


SELECT SCHOOL_NAME
,      ADDR_USE_TYPE
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
FROM APPS.IGF_SL_LOCAL_INST_V;

Dependencies

[top of page]

APPS.IGF_SL_LOCAL_INST_V references the following:

SchemaAPPS
SynonymHZ_PARTIES
ViewIGF_SL_ADDR_V
SynonymIGS_PE_HZ_PARTIES

APPS.IGF_SL_LOCAL_INST_V is not referenced by any database object