VIEW: APPS.BEN_PLAN_DESIGN_HGRID_VW

Source

View Text - Preformatted

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

View Text - HTML Formatted

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