VIEW: APPS.OKI_SRM_025_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, TRN_CODE, T_RV_AMT_F, T_RV_AMT_G, T_RV_AMT_SG, T_RV_AMT_A, T_BV_AMT_F, T_BV_AMT_G, T_BV_AMT_SG, T_BV_AMT_A, BAL_K_AMT_F, BAL_K_AMT_G, BAL_K_AMT_SG, BAL_K_AMT_A from OKI_SRM_015_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, TRN_CODE, T_RV_AMT_F, T_RV_AMT_G, T_RV_AMT_SG, T_RV_AMT_A, T_BV_AMT_F, T_BV_AMT_G, T_BV_AMT_SG, T_BV_AMT_A, BAL_K_AMT_F, BAL_K_AMT_G, BAL_K_AMT_SG, BAL_K_AMT_A from OKI_SRM_025_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
, TRN_CODE
, T_RV_AMT_F
, T_RV_AMT_G
, T_RV_AMT_SG
, T_RV_AMT_A
, T_BV_AMT_F
, T_BV_AMT_G
, T_BV_AMT_SG
, T_BV_AMT_A
, BAL_K_AMT_F
, BAL_K_AMT_G
, BAL_K_AMT_SG
, BAL_K_AMT_A
FROM OKI_SRM_015_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
, TRN_CODE
, T_RV_AMT_F
, T_RV_AMT_G
, T_RV_AMT_SG
, T_RV_AMT_A
, T_BV_AMT_F
, T_BV_AMT_G
, T_BV_AMT_SG
, T_BV_AMT_A
, BAL_K_AMT_F
, BAL_K_AMT_G
, BAL_K_AMT_SG
, BAL_K_AMT_A
FROM OKI_SRM_025_MV