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

VIEW: APPS.IGS_AD_LOCATION_ADDR_V

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

View Type

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


Contains the location, venue, and the address details for a person


[View Source]

Columns
Name Datatype Length Mandatory Comments
ROW_ID ROWID (10)
Row identifier
LOCATION_ID NUMBER (15) Yes Location identifier
LOCATION_CD VARCHAR2 (10) Yes Location code
START_DT DATE

Start date
END_DT DATE

End date
ADDR_TYPE VARCHAR2 (30)
Address type
ADDR_LINE_1 VARCHAR2 (240) Yes Address line 1
ADDR_LINE_2 VARCHAR2 (240)
Address line 2
ADDR_LINE_3 VARCHAR2 (240)
Address line 3
ADDR_LINE_4 VARCHAR2 (240)
Address line 4
CONTACT_PERSON VARCHAR2 (40)
Contact person
HL_CREATED_BY NUMBER (15) Yes Standard Who column
HL_CREATION_DATE DATE
Yes Standard Who column
HL_LAST_UPDATED_BY NUMBER (15) Yes Standard Who column
HL_LAST_UPDATE_DATE DATE
Yes Standard Who column
HL_LAST_UPDATE_LOGIN NUMBER (15)
Standard Who column
DATE_LAST_VERIFIED DATE

Last verification date
CORRESPONDENCE_IND VARCHAR2 (1) Yes Correspondence indicator
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
County
COUNTRY VARCHAR2 (60) Yes Country
POSTAL_CODE VARCHAR2 (60)
Postal code
DELIVERY_POINT_CODE VARCHAR2 (50)
Delivery point
OTHER_DETAILS_1 VARCHAR2 (40)
Other details 1
OTHER_DETAILS_2 VARCHAR2 (40)
Other details 2
OTHER_DETAILS_3 VARCHAR2 (40)
Other details 3
HL_REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update
HL_PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update
HL_PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update
HL_PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
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) Yes Standard Who column
REQUEST_ID NUMBER (15)
Request identifier of last concurrent program to update
PROGRAM_APPLICATION_ID NUMBER (15)
Application identifier of last concurrent program to update
PROGRAM_ID NUMBER (15)
Program identifier of last concurrent program to update
PROGRAM_UPDATE_DATE DATE

Last update date of this record by a concurrent program
Query Text

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


SELECT ROW_ID
,      LOCATION_ID
,      LOCATION_CD
,      START_DT
,      END_DT
,      ADDR_TYPE
,      ADDR_LINE_1
,      ADDR_LINE_2
,      ADDR_LINE_3
,      ADDR_LINE_4
,      CONTACT_PERSON
,      HL_CREATED_BY
,      HL_CREATION_DATE
,      HL_LAST_UPDATED_BY
,      HL_LAST_UPDATE_DATE
,      HL_LAST_UPDATE_LOGIN
,      DATE_LAST_VERIFIED
,      CORRESPONDENCE_IND
,      CITY
,      STATE
,      PROVINCE
,      COUNTY
,      COUNTRY
,      POSTAL_CODE
,      DELIVERY_POINT_CODE
,      OTHER_DETAILS_1
,      OTHER_DETAILS_2
,      OTHER_DETAILS_3
,      HL_REQUEST_ID
,      HL_PROGRAM_APPLICATION_ID
,      HL_PROGRAM_ID
,      HL_PROGRAM_UPDATE_DATE
,      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_AD_LOCATION_ADDR_V;

Dependencies

[top of page]

APPS.IGS_AD_LOCATION_ADDR_V references the following:

SchemaAPPS
SynonymHZ_LOCATIONS
SynonymIGS_AD_LOCVENUE_ADDR
SynonymIGS_PE_HZ_LOCATIONS
SynonymIGS_PE_LOCVENUE_USE

APPS.IGS_AD_LOCATION_ADDR_V is not referenced by any database object