VIEW: APPS.CS_SYSTEM_PARTY_LINKS_V

Source

View Text - Preformatted

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,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

View Text - HTML Formatted

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
, 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