VIEW: APPS.HZ_DSS_SEL_ENTITIES_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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