VIEW: APPS.BNE_GRAPHS_VL

Source

View Text - Preformatted

SELECT G.ROWID ROW_ID, G.APPLICATION_ID, G.INTEGRATOR_CODE, G.SEQUENCE_NUM, G.OBJECT_VERSION_NUMBER, G.LAYOUT_APP_ID, G.LAYOUT_CODE, G.GRAPH_DIMENSION_CODE, G.GRAPH_TYPE_CODE, G.AUTO_GRAPH_FLAG, T.CHART_TITLE, T.X_AXIS_LABEL, T.Y_AXIS_LABEL, T.Z_AXIS_LABEL, G.CREATED_BY, G.CREATION_DATE, G.LAST_UPDATED_BY, G.LAST_UPDATE_LOGIN, G.LAST_UPDATE_DATE FROM BNE_GRAPHS_B G, BNE_GRAPHS_TL T WHERE G.APPLICATION_ID = T.APPLICATION_ID AND G.INTEGRATOR_CODE = T.INTEGRATOR_CODE AND G.SEQUENCE_NUM = T.SEQUENCE_NUM AND T.LANGUAGE=USERENV('LANG')

View Text - HTML Formatted

SELECT G.ROWID ROW_ID
, G.APPLICATION_ID
, G.INTEGRATOR_CODE
, G.SEQUENCE_NUM
, G.OBJECT_VERSION_NUMBER
, G.LAYOUT_APP_ID
, G.LAYOUT_CODE
, G.GRAPH_DIMENSION_CODE
, G.GRAPH_TYPE_CODE
, G.AUTO_GRAPH_FLAG
, T.CHART_TITLE
, T.X_AXIS_LABEL
, T.Y_AXIS_LABEL
, T.Z_AXIS_LABEL
, G.CREATED_BY
, G.CREATION_DATE
, G.LAST_UPDATED_BY
, G.LAST_UPDATE_LOGIN
, G.LAST_UPDATE_DATE
FROM BNE_GRAPHS_B G
, BNE_GRAPHS_TL T
WHERE G.APPLICATION_ID = T.APPLICATION_ID
AND G.INTEGRATOR_CODE = T.INTEGRATOR_CODE
AND G.SEQUENCE_NUM = T.SEQUENCE_NUM
AND T.LANGUAGE=USERENV('LANG')