eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: CS_SYSTEM_PARTY_LINKS_V

Product:	CS - Service
Description:
Implementation/DBA Data:	APPS.CS_SYSTEM_PARTY_LINKS_V

View Text

SELECT CS_PARTY_LINK.PARTY_ID
, CS_PARTY_LINK.SYSTEM_ID
, CS_PARTY_LINK.START_DATE
, CS_PARTY_LINK.END_DATE
, HZ_PARTY.PARTY_NAME
, HZ_PARTY.PERSON_FIRST_NAME
, HZ_PARTY.PERSON_LAST_NAME
, HZ_PARTY.ADDRESS1
, HZ_PARTY.ADDRESS2
, HZ_PARTY.ADDRESS3
, HZ_PARTY.ADDRESS4
, HZ_PARTY.CITY
, HZ_PARTY.POSTAL_CODE
, HZ_PARTY.STATE
, HZ_PARTY.COUNTRY
, HZ_PARTY.EMAIL_ADDRESS
, F_USER.USER_ID
, F_USER.USER_NAME
, F_USER.LAST_LOGON_DATE
, CS_SYSTEM.NAME
, CS_SYSTEM.PARENT_SYSTEM_ID
, CS_SYSTEM.CUSTOMER_ID
, CS_SYSTEM.TECHNICAL_CONTACT_ID
, CS_SYSTEM.SERVICE_ADMIN_CONTACT_ID
, CS_SYSTEM.START_DATE_ACTIVE
, CS_SYSTEM.END_DATE_ACTIVE
, CS_SYSTEM.COTERMINATE_DAY_MONTH
, CS_SYSTEM.ORG_ID
, CS_PARTY_LINK.LAST_UPDATED_BY
, CS_PARTY_LINK.CREATED_BY
FROM CS_SYSTEM_PARTY_LINKS CS_PARTY_LINK
, HZ_PARTIES HZ_PARTY
, CS_SYSTEMS_ALL_VL CS_SYSTEM
, FND_USER F_USER
WHERE CS_PARTY_LINK.PARTY_ID = HZ_PARTY.PARTY_ID
AND F_USER.CUSTOMER_ID = CS_PARTY_LINK.PARTY_ID
AND CS_PARTY_LINK.SYSTEM_ID=CS_SYSTEM.SYSTEM_ID

Columns

Name
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