CSO_FA_USER_RO_V

Details

• Schema: FUSION

• Object owner: CSO

• Object type: VIEW

Columns

Name
RECORD_ID FIRST_NAME LAST_NAME EMAIL ACTIVE STATUS PER_USERS_ACTIVE_FLAG PER_USERS_SUSPENDED LOGIN USER_GUID PARTY_TYPE ADMIN_USER EXTERNAL_TYPE IS_DEFAULT_ADMINISTRATOR OWNER_SITE_ID TYPE_LOOKUP_CODE_ID

Query

SQL_Statement

SELECT AllPartyEO.PARTY_ID AS RECORD_ID, AllPartyEO.PERSON_FIRST_NAME AS FIRST_NAME, AllPartyEO.PERSON_LAST_NAME AS LAST_NAME, AllPartyEO.EMAIL_ADDRESS AS EMAIL, CASE AllPartyEO.STATUS WHEN 'A' THEN 'Y' ELSE 'N' END AS ACTIVE, AllPartyEO.STATUS AS STATUS, AllUsersEO.ACTIVE_FLAG AS PER_USERS_ACTIVE_FLAG, AllUsersEO.SUSPENDED AS PER_USERS_SUSPENDED, AllUsersEO.USERNAME AS LOGIN, AllPartyEO.USER_GUID, AllPartyEO.PARTY_TYPE, 'Y' as ADMIN_USER, 'ACCOUNT' as EXTERNAL_TYPE, 'N' as IS_DEFAULT_ADMINISTRATOR, 'FBA17E28CAAB4A7387A44BEE77240E33' as OWNER_SITE_ID, '0784E69691F3CFF6E050007F010001D2' as TYPE_LOOKUP_CODE_ID FROM HZ_PARTIES AllPartyEO LEFT OUTER JOIN PER_USERS AllUsersEO ON AllUsersEO.USER_GUID = AllPartyEO.USER_GUID WHERE AllPartyEO.STATUS = 'A' AND AllPartyEO.PARTY_ID NOT IN (-999997, -999998, -999999) UNION ALL SELECT CAST (-999997 AS NUMBER(18)) AS RECORD_ID, 'Deleted' AS FIRST_NAME, 'User' AS LAST_NAME, null AS EMAIL, 'Y' AS ACTIVE, 'A' AS STATUS, 'Y' AS PER_USERS_ACTIVE_FLAG, 'N' AS PER_USERS_SUSPENDED, 'km_internal_deleted_user_999997' AS LOGIN, 'km_internal_deleted_user_999997' AS USER_GUID, 'PERSON' AS PARTY_TYPE, 'Y' AS ADMIN_USER, 'ACCOUNT' AS EXTERNAL_TYPE, 'N' AS IS_DEFAULT_ADMINISTRATOR, 'FBA17E28CAAB4A7387A44BEE77240E33' AS OWNER_SITE_ID, '0784E69691F3CFF6E050007F010001D2' AS TYPE_LOOKUP_CODE_ID FROM CSO_LOOKUP_CODE lc WHERE lc.RECORD_ID = '0784E69691F3CFF6E050007F010001D2' UNION ALL SELECT CAST (-999998 AS NUMBER(18)) AS RECORD_ID, 'BatchJob' AS FIRST_NAME, 'User' AS LAST_NAME, null AS EMAIL, 'Y' AS ACTIVE, 'A' AS STATUS, 'Y' AS PER_USERS_ACTIVE_FLAG, 'N' AS PER_USERS_SUSPENDED, 'km_internal_batchjob_user_999998' AS LOGIN, 'km_internal_batchjob_user_999998' AS USER_GUID, 'PERSON' AS PARTY_TYPE, 'Y' AS ADMIN_USER, 'ACCOUNT' AS EXTERNAL_TYPE, 'N' AS IS_DEFAULT_ADMINISTRATOR, 'FBA17E28CAAB4A7387A44BEE77240E33' AS OWNER_SITE_ID, '0784E69691F3CFF6E050007F010001D2' AS TYPE_LOOKUP_CODE_ID FROM CSO_LOOKUP_CODE lc WHERE lc.RECORD_ID = '0784E69691F3CFF6E050007F010001D2' UNION ALL SELECT CAST (-999999 AS NUMBER(18)) AS RECORD_ID, 'Guest' AS FIRST_NAME, 'User' AS LAST_NAME, null AS EMAIL, 'Y' AS ACTIVE, 'A' AS STATUS, 'Y' AS PER_USERS_ACTIVE_FLAG, 'N' AS PER_USERS_SUSPENDED, 'km_internal_guest_999999' AS LOGIN, 'km_internal_guest_999999' AS USER_GUID, 'PERSON' AS PARTY_TYPE, 'N' AS ADMIN_USER, 'CONTACT' AS EXTERNAL_TYPE, 'N' AS IS_DEFAULT_ADMINISTRATOR, 'FBA17E28CAAB4A7387A44BEE77240E33' AS OWNER_SITE_ID, '1ED7FB7A3295441ABBBB63A8BB58EA39' AS TYPE_LOOKUP_CODE_ID FROM CSO_LOOKUP_CODE lc WHERE lc.RECORD_ID = '1ED7FB7A3295441ABBBB63A8BB58EA39'