VIEW: APPS.BIM_DIMV_TARGET_SGMTS

Source

View Text - Preformatted

SELECT id, (select cell_name from ams_cells_all_tl where cell_id=id and language=userenv('LANG')) value, node,null target_segment_id,null target_segment_code,null target_segment_name,null description, null original_size, null parent_id, null enabled_flag from ( select segs.cell_id id,segs.parent_cell_id node from ams_cells_all_b segs where segs.parent_cell_id is not null union all select segs.cell_id id,segs.cell_id node from ams_cells_all_b segs union all select segs.parent_cell_id id,segs.cell_id node from ams_cells_all_b segs WHERE parent_cell_id IS NOT NULL UNION ALL SELECT segment_id, TO_NUMBER (NULL) FROM bim_i_sgmt_denorm WHERE parent_segment_id = segment_id AND top_node_flag = 'Y' )

View Text - HTML Formatted

SELECT ID
, (SELECT CELL_NAME
FROM AMS_CELLS_ALL_TL
WHERE CELL_ID=ID
AND LANGUAGE=USERENV('LANG')) VALUE
, NODE
, NULL TARGET_SEGMENT_ID
, NULL TARGET_SEGMENT_CODE
, NULL TARGET_SEGMENT_NAME
, NULL DESCRIPTION
, NULL ORIGINAL_SIZE
, NULL PARENT_ID
, NULL ENABLED_FLAG
FROM ( SELECT SEGS.CELL_ID ID
, SEGS.PARENT_CELL_ID NODE
FROM AMS_CELLS_ALL_B SEGS
WHERE SEGS.PARENT_CELL_ID IS NOT NULL UNION ALL SELECT SEGS.CELL_ID ID
, SEGS.CELL_ID NODE
FROM AMS_CELLS_ALL_B SEGS UNION ALL SELECT SEGS.PARENT_CELL_ID ID
, SEGS.CELL_ID NODE
FROM AMS_CELLS_ALL_B SEGS
WHERE PARENT_CELL_ID IS NOT NULL UNION ALL SELECT SEGMENT_ID
, TO_NUMBER (NULL)
FROM BIM_I_SGMT_DENORM
WHERE PARENT_SEGMENT_ID = SEGMENT_ID
AND TOP_NODE_FLAG = 'Y' )