SVC_HELPDESK_CONTACTS_V

Details

• Schema: FUSION

• Object owner: SVC

• Object type: VIEW

Columns

Name
PARTY_ID PARTY_USG_ASSIGNMENT_ID OBJECT_VERSION_NUMBER PARTY_USAGE_CODE

Query

SQL_Statement
SELECT party_id, party_usg_assignment_id, object_version_number, party_usage_code FROM ( SELECT party_id, party_usg_assignment_id, object_version_number, party_usage_code, RANK() OVER(PARTITION BY party_id ORDER BY party_usg_assignment_id DESC ) rnk FROM hz_party_usg_assignments WHERE party_usage_code IN ( 'HR_EMPLOYEE', 'HR_CONTINGENT_WORKER') ) WHERE rnk = 1