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

VIEW: APPS.CS_SR_SYSTEMS_V

Object Details
Object Name: CS_SR_SYSTEMS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_SYSTEMS_V
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
SYSTEM_ID NUMBER
Yes System Identification Number
NAME VARCHAR2 (50) Yes System Name
DESCRIPTION VARCHAR2 (240)
Description of the System
PARTY_NAME VARCHAR2 (360) Yes Party Name
PARTY_NUMBER VARCHAR2 (30) Yes Party Number
EMAIL_ADDRESS VARCHAR2 (2000)
Email Address
ADDRESS VARCHAR2 (963)
Concated Address
CITY VARCHAR2 (60)
City
STATE VARCHAR2 (60)
State
COUNTRY VARCHAR2 (60)
Country
PROVINCE VARCHAR2 (60)
Province
POSTAL_CODE VARCHAR2 (60)
Postal Code
PARTY_ID NUMBER (15) Yes Party Identification Number
CALLER_TYPE VARCHAR2 (12)
Caller Type
KNOWN_AS VARCHAR2 (240)
Party known as.
Query Text

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


SELECT SYSTEM_ID
,      NAME
,      DESCRIPTION
,      PARTY_NAME
,      PARTY_NUMBER
,      EMAIL_ADDRESS
,      ADDRESS
,      CITY
,      STATE
,      COUNTRY
,      PROVINCE
,      POSTAL_CODE
,      PARTY_ID
,      CALLER_TYPE
,      KNOWN_AS
FROM APPS.CS_SR_SYSTEMS_V;

Dependencies

[top of page]

APPS.CS_SR_SYSTEMS_V references the following:

SchemaAPPS
ViewCSI_SYSTEMS_VL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
APPS.CS_SR_SYSTEMS_V is referenced by following:

SchemaAPPS
ViewCS_AUDIT_REPORT_VW