[Home] [Help]
View: HZ_DSS_SEL_ENTITIES_V
View Text
SELECT HDG.DSS_GROUP_CODE
, HDE.ENTITY_ID
, HDE.OBJECT_ID
, HDE.INSTANCE_SET_ID
, NVL((SELECT 'Y'
FROM HZ_DSS_SECURED_ENTITIES DSE
WHERE DSE.ENTITY_ID = HDE.ENTITY_ID
AND DSE.DSS_GROUP_CODE = HDG.DSS_GROUP_CODE
AND DSE.STATUS = 'A')
, 'N') SELECTED_FLAG
, (SELECT OBJECT_VERSION_NUMBER
FROM HZ_DSS_SECURED_ENTITIES DSE2
WHERE DSE2.ENTITY_ID = HDE.ENTITY_ID
AND DSE2.DSS_GROUP_CODE = HDG.DSS_GROUP_CODE) OBJECT_VERSION_NUMBER
, (SELECT STATUS
FROM HZ_DSS_SECURED_ENTITIES DSE3
WHERE DSE3.ENTITY_ID = HDE.ENTITY_ID
AND DSE3.DSS_GROUP_CODE = HDG.DSS_GROUP_CODE) HSE_STATUS
, HDE.STATUS HDE_STATUS
, FO.OBJ_NAME
, FOIS.INSTANCE_SET_NAME
, NVL(FOIS.DISPLAY_NAME
, FO.DISPLAY_NAME) ENTITY_DISPLAY_NAME
, NVL(FOIS.DESCRIPTION
, FO.DESCRIPTION) ENTITY_DESCRIPTION
FROM HZ_DSS_GROUPS_B HDG
, HZ_DSS_ENTITIES HDE
, FND_OBJECTS_VL FO
, FND_OBJECT_INSTANCE_SETS_VL FOIS
WHERE FO.OBJECT_ID (+) = HDE.OBJECT_ID
AND FOIS.INSTANCE_SET_ID (+) = HDE.INSTANCE_SET_ID
Columns
Name |
DSS_GROUP_CODE |
ENTITY_ID |
OBJECT_ID |
INSTANCE_SET_ID |
SELECTED_FLAG |
OBJECT_VERSION_NUMBER |
HSE_STATUS |
HDE_STATUS |
OBJ_NAME |
INSTANCE_SET_NAME |
ENTITY_DISPLAY_NAME |
ENTITY_DESCRIPTION |