Product: | BEN - Advanced Benefits |
---|---|
Description: | Plan Design H-Grid View |
Implementation/DBA Data: | APPS.BEN_PLAN_DESIGN_HGRID_VW |
SELECT DISTINCT -1 COPY_ENTITY_RESULT_ID
, CER.COPY_ENTITY_TXN_ID
, -1 NUMBER_OF_COPIES
, -1 OBJECT_VERSION_NUMBER
, CER.PARENT_ENTITY_RESULT_ID
, CER.TABLE_ROUTE_ID
, TRE.DISPLAY_NAME NAME
, 'LABEL' TYPE
, 'Y' SELECTION_DISABLED_FLAG
, 'ORADATATEXT' CSSSTYLE
, -1 MIRROR_ENTITY_RESULT_ID
, NULL INFORMATION8
FROM /* PQH_COPY_ENTITY_RESULTS CER
, */ BEN_COPY_ENTITY_RESULTS CER
, PQH_TABLE_ROUTE_VL TRE
WHERE CER.TABLE_ROUTE_ID = TRE.TABLE_ROUTE_ID
AND TRE.HIDE_TABLE_FOR_VIEW_FLAG = 'N'
AND CER.RESULT_TYPE_CD = 'DISPLAY' UNION SELECT CER.COPY_ENTITY_RESULT_ID
, CER.COPY_ENTITY_TXN_ID
, CER.NUMBER_OF_COPIES
, CER.OBJECT_VERSION_NUMBER
, NVL(CER.PARENT_ENTITY_RESULT_ID
, -1) PARENT_ENTITY_RESULT_ID
, CER.TABLE_ROUTE_ID
, CER.INFORMATION5 NAME
, 'DATA' TYPE
, DECODE(TRE.SELECT_ALLOWED_FLAG
, 'Y'
, 'N'
, 'N'
, 'Y') SELECTION_DISABLED_FLAG
, 'ORATABLECELLTEXT' CSSSTYLE
, CER.MIRROR_ENTITY_RESULT_ID
, CER.INFORMATION8
FROM /* PQH_COPY_ENTITY_RESULTS CER
, */ BEN_COPY_ENTITY_RESULTS CER
, PQH_TABLE_ROUTE_VL TRE
WHERE CER.TABLE_ROUTE_ID = TRE.TABLE_ROUTE_ID
AND CER.RESULT_TYPE_CD = 'DISPLAY' ORDER BY NAME