VIEW: APPS.OKI_SRM_023_V

Source

View Text - Preformatted

SELECT UMARKER, AUTHORING_ORG_ID, RG_ID, PRG_ID , RESOURCE_ID, CLASS_CODE, SERVICE_ITEM_ORG_ID, SERVICE_ITEM_CATEGORY_ID, CC_FLAG, TIME_ID, X_RG_AMT_F, X_RG_AMT_G, X_RG_AMT_SG, X_RG_AMT_A, X_RC_AMT_F, X_RC_AMT_G, X_RC_AMT_SG, X_RC_AMT_A, X_RO_O_AMT_F, X_RO_O_AMT_G, X_RO_O_AMT_SG, X_RO_O_AMT_A, X_RD_O_AMT_F, X_RD_O_AMT_G, X_RD_O_AMT_SG, X_RD_O_AMT_A, BAL_K_AMT_F, BAL_K_AMT_G, BAL_K_AMT_SG, BAL_K_AMT_A from OKI_SRM_013_MV union all select UMARKER, AUTHORING_ORG_ID, RG_ID, PRG_ID , RESOURCE_ID, CLASS_CODE, SERVICE_ITEM_ORG_ID, SERVICE_ITEM_CATEGORY_ID, CC_FLAG, TIME_ID, X_RG_AMT_F, X_RG_AMT_G, X_RG_AMT_SG, X_RG_AMT_A, X_RC_AMT_F, X_RC_AMT_G, X_RC_AMT_SG, X_RC_AMT_A, X_RO_O_AMT_F, X_RO_O_AMT_G, X_RO_O_AMT_SG, X_RO_O_AMT_A, X_RD_O_AMT_F, X_RD_O_AMT_G, X_RD_O_AMT_SG, X_RD_O_AMT_A, BAL_K_AMT_F, BAL_K_AMT_G, BAL_K_AMT_SG, BAL_K_AMT_A from OKI_SRM_023_MV

View Text - HTML Formatted

SELECT UMARKER
, AUTHORING_ORG_ID
, RG_ID
, PRG_ID
, RESOURCE_ID
, CLASS_CODE
, SERVICE_ITEM_ORG_ID
, SERVICE_ITEM_CATEGORY_ID
, CC_FLAG
, TIME_ID
, X_RG_AMT_F
, X_RG_AMT_G
, X_RG_AMT_SG
, X_RG_AMT_A
, X_RC_AMT_F
, X_RC_AMT_G
, X_RC_AMT_SG
, X_RC_AMT_A
, X_RO_O_AMT_F
, X_RO_O_AMT_G
, X_RO_O_AMT_SG
, X_RO_O_AMT_A
, X_RD_O_AMT_F
, X_RD_O_AMT_G
, X_RD_O_AMT_SG
, X_RD_O_AMT_A
, BAL_K_AMT_F
, BAL_K_AMT_G
, BAL_K_AMT_SG
, BAL_K_AMT_A
FROM OKI_SRM_013_MV UNION ALL SELECT UMARKER
, AUTHORING_ORG_ID
, RG_ID
, PRG_ID
, RESOURCE_ID
, CLASS_CODE
, SERVICE_ITEM_ORG_ID
, SERVICE_ITEM_CATEGORY_ID
, CC_FLAG
, TIME_ID
, X_RG_AMT_F
, X_RG_AMT_G
, X_RG_AMT_SG
, X_RG_AMT_A
, X_RC_AMT_F
, X_RC_AMT_G
, X_RC_AMT_SG
, X_RC_AMT_A
, X_RO_O_AMT_F
, X_RO_O_AMT_G
, X_RO_O_AMT_SG
, X_RO_O_AMT_A
, X_RD_O_AMT_F
, X_RD_O_AMT_G
, X_RD_O_AMT_SG
, X_RD_O_AMT_A
, BAL_K_AMT_F
, BAL_K_AMT_G
, BAL_K_AMT_SG
, BAL_K_AMT_A
FROM OKI_SRM_023_MV