VIEW: APPS.PA_OLAP_XBS_DENORM_V

Source

View Text - Preformatted

SELECT /*+ orderd */ STRUCT_TYPE,PRG_GROUP,STRUCT_VERSION_ID,SUP_PROJECT_ID,SUP_ID,SUP_EMT_ID,SUBRO_ID,SUB_ID, SUB_EMT_ID,SUP_LEVEL,SUB_LEVEL,SUB_ROLLUP_ID,SUB_LEAF_FLAG, LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN, STRUCT_EMT_ID,RELATIONSHIP_TYPE from pji_xbs_denorm where PA_olap_PVT.G_pjt_rollup_flag = 'N' union all select /*+ orderd */ STRUCT_TYPE,PRG_GROUP,STRUCT_VERSION_ID,SUP_PROJECT_ID,SUP_ID,SUP_EMT_ID,SUBRO_ID,SUB_ID, SUB_EMT_ID,SUP_LEVEL,SUB_LEVEL,SUB_ROLLUP_ID,SUB_LEAF_FLAG, LAST_UPDATE_DATE,LAST_UPDATED_BY,CREATION_DATE,CREATED_BY,LAST_UPDATE_LOGIN, STRUCT_EMT_ID,RELATIONSHIP_TYPE from pa_olap_xbs_denorm_TMP where PA_olap_PVT.G_pjt_rollup_flag = 'Y'

View Text - HTML Formatted

SELECT /*+ ORDERD */ STRUCT_TYPE
, PRG_GROUP
, STRUCT_VERSION_ID
, SUP_PROJECT_ID
, SUP_ID
, SUP_EMT_ID
, SUBRO_ID
, SUB_ID
, SUB_EMT_ID
, SUP_LEVEL
, SUB_LEVEL
, SUB_ROLLUP_ID
, SUB_LEAF_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, STRUCT_EMT_ID
, RELATIONSHIP_TYPE
FROM PJI_XBS_DENORM
WHERE PA_OLAP_PVT.G_PJT_ROLLUP_FLAG = 'N' UNION ALL SELECT /*+ ORDERD */ STRUCT_TYPE
, PRG_GROUP
, STRUCT_VERSION_ID
, SUP_PROJECT_ID
, SUP_ID
, SUP_EMT_ID
, SUBRO_ID
, SUB_ID
, SUB_EMT_ID
, SUP_LEVEL
, SUB_LEVEL
, SUB_ROLLUP_ID
, SUB_LEAF_FLAG
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, STRUCT_EMT_ID
, RELATIONSHIP_TYPE
FROM PA_OLAP_XBS_DENORM_TMP
WHERE PA_OLAP_PVT.G_PJT_ROLLUP_FLAG = 'Y'