VIEW: APPS.OKI_SRM_021_V

Source

View Text - Preformatted

SELECT UMARKER, AUTHORING_ORG_ID, RG_ID, PRG_ID , RESOURCE_ID, SERVICE_ITEM_ORG_ID, SERVICE_ITEM_CATEGORY_ID, CLASS_CODE, CC_FLAG, TIME_ID, S_R_AMT_F, S_R_AMT_G, S_R_AMT_SG, S_R_AMT_A, S_GPR_AMT_Y_F, S_GPR_AMT_Y_G, S_GPR_AMT_Y_SG , S_GPR_AMT_Y_A, S_GPR_AMT_Q_F, S_GPR_AMT_Q_G, S_GPR_AMT_Q_SG , S_GPR_AMT_Q_A, S_GPR_AMT_P_F, S_GPR_AMT_P_G, S_GPR_AMT_P_SG , S_GPR_AMT_P_A, S_GPO_AMT_Y_F, S_GPO_AMT_Y_G, S_GPO_AMT_Y_SG , S_GPO_AMT_Y_A, S_GPO_AMT_Q_F, S_GPO_AMT_Q_G, S_GPO_AMT_Q_SG , S_GPO_AMT_Q_A, S_GPO_AMT_P_F, S_GPO_AMT_P_G, S_GPO_AMT_P_SG , S_GPO_AMT_P_A, C_SCR_AMT_F, C_SCR_AMT_G, C_SCR_AMT_SG, C_SCR_AMT_A, B_R_AMT_F, B_R_AMT_G, B_R_AMT_SG, B_R_AMT_A, S_G_O_AMT_F, S_G_O_AMT_G, S_G_O_AMT_SG, S_G_O_AMT_A, S_R_O_AMT_F, S_R_O_AMT_G, S_R_O_AMT_SG, S_R_O_AMT_A, S_X_R_AMT_F, S_X_R_AMT_G, S_X_R_AMT_SG, S_X_R_AMT_A, S_G_AMT_F, S_G_AMT_G, S_G_AMT_SG, S_G_AMT_A, S_RG_AMT_F, S_RG_AMT_G, S_RG_AMT_SG, S_RG_AMT_A, S_XG_R_AMT_F, S_XG_R_AMT_G, S_XG_R_AMT_SG, S_XG_R_AMT_A from OKI_SRM_011_MV union all select UMARKER, AUTHORING_ORG_ID, RG_ID, PRG_ID , RESOURCE_ID, SERVICE_ITEM_ORG_ID, SERVICE_ITEM_CATEGORY_ID, CLASS_CODE, CC_FLAG, TIME_ID, S_R_AMT_F, S_R_AMT_G, S_R_AMT_SG, S_R_AMT_A, S_GPR_AMT_Y_F, S_GPR_AMT_Y_G, S_GPR_AMT_Y_SG , S_GPR_AMT_Y_A, S_GPR_AMT_Q_F, S_GPR_AMT_Q_G, S_GPR_AMT_Q_SG , S_GPR_AMT_Q_A, S_GPR_AMT_P_F, S_GPR_AMT_P_G, S_GPR_AMT_P_SG , S_GPR_AMT_P_A, S_GPO_AMT_Y_F, S_GPO_AMT_Y_G, S_GPO_AMT_Y_SG , S_GPO_AMT_Y_A, S_GPO_AMT_Q_F, S_GPO_AMT_Q_G, S_GPO_AMT_Q_SG , S_GPO_AMT_Q_A, S_GPO_AMT_P_F, S_GPO_AMT_P_G, S_GPO_AMT_P_SG , S_GPO_AMT_P_A, C_SCR_AMT_F, C_SCR_AMT_G, C_SCR_AMT_SG, C_SCR_AMT_A, B_R_AMT_F, B_R_AMT_G, B_R_AMT_SG, B_R_AMT_A, S_G_O_AMT_F, S_G_O_AMT_G, S_G_O_AMT_SG, S_G_O_AMT_A, S_R_O_AMT_F, S_R_O_AMT_G, S_R_O_AMT_SG, S_R_O_AMT_A, S_X_R_AMT_F, S_X_R_AMT_G, S_X_R_AMT_SG, S_X_R_AMT_A, S_G_AMT_F, S_G_AMT_G, S_G_AMT_SG, S_G_AMT_A, S_RG_AMT_F, S_RG_AMT_G, S_RG_AMT_SG, S_RG_AMT_A, S_XG_R_AMT_F, S_XG_R_AMT_G, S_XG_R_AMT_SG, S_XG_R_AMT_A from OKI_SRM_021_MV

View Text - HTML Formatted

SELECT UMARKER
, AUTHORING_ORG_ID
, RG_ID
, PRG_ID
, RESOURCE_ID
, SERVICE_ITEM_ORG_ID
, SERVICE_ITEM_CATEGORY_ID
, CLASS_CODE
, CC_FLAG
, TIME_ID
, S_R_AMT_F
, S_R_AMT_G
, S_R_AMT_SG
, S_R_AMT_A
, S_GPR_AMT_Y_F
, S_GPR_AMT_Y_G
, S_GPR_AMT_Y_SG
, S_GPR_AMT_Y_A
, S_GPR_AMT_Q_F
, S_GPR_AMT_Q_G
, S_GPR_AMT_Q_SG
, S_GPR_AMT_Q_A
, S_GPR_AMT_P_F
, S_GPR_AMT_P_G
, S_GPR_AMT_P_SG
, S_GPR_AMT_P_A
, S_GPO_AMT_Y_F
, S_GPO_AMT_Y_G
, S_GPO_AMT_Y_SG
, S_GPO_AMT_Y_A
, S_GPO_AMT_Q_F
, S_GPO_AMT_Q_G
, S_GPO_AMT_Q_SG
, S_GPO_AMT_Q_A
, S_GPO_AMT_P_F
, S_GPO_AMT_P_G
, S_GPO_AMT_P_SG
, S_GPO_AMT_P_A
, C_SCR_AMT_F
, C_SCR_AMT_G
, C_SCR_AMT_SG
, C_SCR_AMT_A
, B_R_AMT_F
, B_R_AMT_G
, B_R_AMT_SG
, B_R_AMT_A
, S_G_O_AMT_F
, S_G_O_AMT_G
, S_G_O_AMT_SG
, S_G_O_AMT_A
, S_R_O_AMT_F
, S_R_O_AMT_G
, S_R_O_AMT_SG
, S_R_O_AMT_A
, S_X_R_AMT_F
, S_X_R_AMT_G
, S_X_R_AMT_SG
, S_X_R_AMT_A
, S_G_AMT_F
, S_G_AMT_G
, S_G_AMT_SG
, S_G_AMT_A
, S_RG_AMT_F
, S_RG_AMT_G
, S_RG_AMT_SG
, S_RG_AMT_A
, S_XG_R_AMT_F
, S_XG_R_AMT_G
, S_XG_R_AMT_SG
, S_XG_R_AMT_A
FROM OKI_SRM_011_MV UNION ALL SELECT UMARKER
, AUTHORING_ORG_ID
, RG_ID
, PRG_ID
, RESOURCE_ID
, SERVICE_ITEM_ORG_ID
, SERVICE_ITEM_CATEGORY_ID
, CLASS_CODE
, CC_FLAG
, TIME_ID
, S_R_AMT_F
, S_R_AMT_G
, S_R_AMT_SG
, S_R_AMT_A
, S_GPR_AMT_Y_F
, S_GPR_AMT_Y_G
, S_GPR_AMT_Y_SG
, S_GPR_AMT_Y_A
, S_GPR_AMT_Q_F
, S_GPR_AMT_Q_G
, S_GPR_AMT_Q_SG
, S_GPR_AMT_Q_A
, S_GPR_AMT_P_F
, S_GPR_AMT_P_G
, S_GPR_AMT_P_SG
, S_GPR_AMT_P_A
, S_GPO_AMT_Y_F
, S_GPO_AMT_Y_G
, S_GPO_AMT_Y_SG
, S_GPO_AMT_Y_A
, S_GPO_AMT_Q_F
, S_GPO_AMT_Q_G
, S_GPO_AMT_Q_SG
, S_GPO_AMT_Q_A
, S_GPO_AMT_P_F
, S_GPO_AMT_P_G
, S_GPO_AMT_P_SG
, S_GPO_AMT_P_A
, C_SCR_AMT_F
, C_SCR_AMT_G
, C_SCR_AMT_SG
, C_SCR_AMT_A
, B_R_AMT_F
, B_R_AMT_G
, B_R_AMT_SG
, B_R_AMT_A
, S_G_O_AMT_F
, S_G_O_AMT_G
, S_G_O_AMT_SG
, S_G_O_AMT_A
, S_R_O_AMT_F
, S_R_O_AMT_G
, S_R_O_AMT_SG
, S_R_O_AMT_A
, S_X_R_AMT_F
, S_X_R_AMT_G
, S_X_R_AMT_SG
, S_X_R_AMT_A
, S_G_AMT_F
, S_G_AMT_G
, S_G_AMT_SG
, S_G_AMT_A
, S_RG_AMT_F
, S_RG_AMT_G
, S_RG_AMT_SG
, S_RG_AMT_A
, S_XG_R_AMT_F
, S_XG_R_AMT_G
, S_XG_R_AMT_SG
, S_XG_R_AMT_A
FROM OKI_SRM_021_MV