[Home] [Help]
View: WF_HZ_GROUP_UR
| Product: | FND - Application Object Library |
|---|
| Description: | |
|---|
| Implementation/DBA Data: |
Not implemented in this database
|
|---|
View Text
SELECT 'HZ_PARTY:'||TO_CHAR(SP.PARTY_ID) USER_NAME
, 'HZ_PARTY' USER_ORIG_SYSTEM
, SP.PARTY_ID USER_ORIG_SYSTEM_ID
, 'HZ_GROUP:'||TO_CHAR(OP.PARTY_ID) ROLE_NAME
, 'HZ_GROUP' ROLE_ORIG_SYSTEM
, OP.PARTY_ID ROLE_ORIG_SYSTEM_ID
, TO_DATE(NULL)
, TO_DATE(NULL)
, NULL
, 8
FROM HZ_PARTY_RELATIONSHIPS PR
, HZ_PARTIES SP
, HZ_PARTIES OP
WHERE SP.PARTY_ID = PR.SUBJECT_ID
AND SP.PARTY_TYPE = 'PERSON'
AND OP.PARTY_ID = PR.OBJECT_ID
AND OP.PARTY_TYPE = 'GROUP'
Columns
| Name |
| USER_NAME |
| USER_ORIG_SYSTEM |
| USER_ORIG_SYSTEM_ID |
| ROLE_NAME |
| ROLE_ORIG_SYSTEM |
| ROLE_ORIG_SYSTEM_ID |
| START_DATE |
| EXPIRATION_DATE |
| SECURITY_GROUP_ID |
| PARTITION_ID |