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

VIEW: APPS.CS_SR_FIND_INCIDENT_ADDRESS_V

Object Details
Object Name: CS_SR_FIND_INCIDENT_ADDRESS_V
Object Type: VIEW
Owner: APPS
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER (15)
Party Id
PARTY_NAME VARCHAR2 (360)
Name of the party
PARTY_NUMBER VARCHAR2 (30)
Party number
PARTY_TYPE VARCHAR2 (30)
Type of PArty
PARTY_SITE_ID NUMBER (15)
Party site Identifier
LOCATION_ID NUMBER (15) Yes Location identifier
LOCATION_TYPE_CODE VARCHAR2 (13)
Location type code
ADDRESS VARCHAR2 (963)
Party address
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
COUNTRY VARCHAR2 (60) Yes Country
PROVINCE VARCHAR2 (60)
Province
COUNTY VARCHAR2 (60)
Name of County
POSTAL_CODE VARCHAR2 (60)
Postal Code
PARTY_SITE_NAME VARCHAR2 (240)
Party site Name
PARTY_SITE_NUMBER VARCHAR2 (30)
Party Site Number
ADDRESSEE VARCHAR2 (360)
Addressee
SITE_PHONE VARCHAR2 (62)
Site Phone
Query Text

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


SELECT PARTY_ID
,      PARTY_NAME
,      PARTY_NUMBER
,      PARTY_TYPE
,      PARTY_SITE_ID
,      LOCATION_ID
,      LOCATION_TYPE_CODE
,      ADDRESS
,      CITY
,      STATE
,      COUNTRY
,      PROVINCE
,      COUNTY
,      POSTAL_CODE
,      PARTY_SITE_NAME
,      PARTY_SITE_NUMBER
,      ADDRESSEE
,      SITE_PHONE
FROM APPS.CS_SR_FIND_INCIDENT_ADDRESS_V;

Dependencies

[top of page]

APPS.CS_SR_FIND_INCIDENT_ADDRESS_V references the following:

SchemaAPPS
SynonymHZ_CONTACT_POINTS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES

APPS.CS_SR_FIND_INCIDENT_ADDRESS_V is not referenced by any database object