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

VIEW: APPS.CS_SYSTEM_PARTY_LINKS_V

Object Details
Object Name: CS_SYSTEM_PARTY_LINKS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SYSTEM_PARTY_LINKS_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 Source]

Columns
Name Datatype Length Mandatory Comments
PARTY_ID NUMBER
Yes
SYSTEM_ID NUMBER
Yes
START_DATE DATE
Yes
END_DATE DATE

PARTY_NAME VARCHAR2 (360) Yes
USER_ID NUMBER (15) Yes
USER_NAME VARCHAR2 (100) Yes
LAST_LOGON_DATE DATE

NAME VARCHAR2 (50) Yes
PARENT_SYSTEM_ID NUMBER

CUSTOMER_ID NUMBER
Yes
TECHNICAL_CONTACT_ID NUMBER

SERVICE_ADMIN_CONTACT_ID NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

COTERMINATE_DAY_MONTH VARCHAR2 (6)
ORG_ID VARCHAR2 (0)
LAST_UPDATED_BY NUMBER
Yes
CREATED_BY NUMBER
Yes
Query Text

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


SELECT PARTY_ID
,      SYSTEM_ID
,      START_DATE
,      END_DATE
,      PARTY_NAME
,      USER_ID
,      USER_NAME
,      LAST_LOGON_DATE
,      NAME
,      PARENT_SYSTEM_ID
,      CUSTOMER_ID
,      TECHNICAL_CONTACT_ID
,      SERVICE_ADMIN_CONTACT_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      COTERMINATE_DAY_MONTH
,      ORG_ID
,      LAST_UPDATED_BY
,      CREATED_BY
FROM APPS.CS_SYSTEM_PARTY_LINKS_V;

Dependencies

[top of page]

APPS.CS_SYSTEM_PARTY_LINKS_V references the following:

SchemaAPPS
SynonymCS_SYSTEMS_ALL_VL
SynonymCS_SYSTEM_PARTY_LINKS
SynonymFND_USER
SynonymHZ_PARTIES
APPS.CS_SYSTEM_PARTY_LINKS_V is referenced by following:

SchemaAPPS
Package BodyCS_SYSTEMS_COMMON_PUB - show dependent code