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

VIEW: APPS.IGS_SV_EV_UPD_SOA_BLK_V

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

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.


View for updating site of activity information for the Exchange Visitor


[View Source]

Columns
Name Datatype Length Mandatory Comments
BATCH_ID NUMBER (14) Yes Batch identifier for the request
PERSON_ID NUMBER (15) Yes Person identifier for the Exchange Visitor in the batch request.
US_ADDRESS_LINE1 VARCHAR2 (60) Yes Site of activity United States Address Line 1
US_ADDRESS_LINE2 VARCHAR2 (60)
Site of activity United States Address Line 2
US_CITY VARCHAR2 (60)
Site of activity United States city.
US_STATE VARCHAR2 (2)
Site of activity United States state
US_POSTAL_CODE VARCHAR2 (20)
Site of activity United States postal code
US_POSTAL_ROUTING_CODE VARCHAR2 (4)
Site of activity United States postal routing code
PARTY_SITE_ID NUMBER (15) Yes Site of activity party site identifier.
SOA_REMARKS VARCHAR2 (500)
Site of activity update remarks
PRIMARY_FLAG VARCHAR2 (1)
Indicator that a Site of Activity is Primary
OLD_PARTY_SITE_NAME VARCHAR2 (162)
Unique Identifier for Site of Activity
NEW_PARTY_SITE_NAME VARCHAR2 (162)
Unique Identifier for Site of Activity
Query Text

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


SELECT BATCH_ID
,      PERSON_ID
,      US_ADDRESS_LINE1
,      US_ADDRESS_LINE2
,      US_CITY
,      US_STATE
,      US_POSTAL_CODE
,      US_POSTAL_ROUTING_CODE
,      PARTY_SITE_ID
,      SOA_REMARKS
,      PRIMARY_FLAG
,      OLD_PARTY_SITE_NAME
,      NEW_PARTY_SITE_NAME
FROM APPS.IGS_SV_EV_UPD_SOA_BLK_V;

Dependencies

[top of page]

APPS.IGS_SV_EV_UPD_SOA_BLK_V references the following:

SchemaAPPS
SynonymIGS_SV_ADDRESSES

APPS.IGS_SV_EV_UPD_SOA_BLK_V is not referenced by any database object