eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: BEN.BEN_COMP_OBJ_CACHE_ROW#

Source

View Text - Preformatted


select COMP_OBJ_CACHE_ROW_ID COMP_OBJ_CACHE_ROW_ID, COMP_OBJ_CACHE_ID COMP_OBJ_CACHE_ID, PGM_ID PGM_ID, PTIP_ID PTIP_ID, PLIP_ID PLIP_ID, PL_ID PL_ID, OIPL_ID OIPL_ID, PL_NIP PL_NIP, ELIG_TRAN_STATE ELIG_TRAN_STATE, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG, PAR_PGM_ID PAR_PGM_ID, PAR_PTIP_ID PAR_PTIP_ID, PAR_PLIP_ID PAR_PLIP_ID, PAR_PL_ID PAR_PL_ID, FLAG_BIT_VAL FLAG_BIT_VAL, OIPLIP_FLAG_BIT_VAL OIPLIP_FLAG_BIT_VAL, OIPLIP_ID OIPLIP_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PAR_OPT_ID PAR_OPT_ID from "BEN"."BEN_COMP_OBJ_CACHE_ROW"

View Text - HTML Formatted

SELECT COMP_OBJ_CACHE_ROW_ID COMP_OBJ_CACHE_ROW_ID
, COMP_OBJ_CACHE_ID COMP_OBJ_CACHE_ID
, PGM_ID PGM_ID
, PTIP_ID PTIP_ID
, PLIP_ID PLIP_ID
, PL_ID PL_ID
, OIPL_ID OIPL_ID
, PL_NIP PL_NIP
, ELIG_TRAN_STATE ELIG_TRAN_STATE
, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG
, PAR_PGM_ID PAR_PGM_ID
, PAR_PTIP_ID PAR_PTIP_ID
, PAR_PLIP_ID PAR_PLIP_ID
, PAR_PL_ID PAR_PL_ID
, FLAG_BIT_VAL FLAG_BIT_VAL
, OIPLIP_FLAG_BIT_VAL OIPLIP_FLAG_BIT_VAL
, OIPLIP_ID OIPLIP_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PAR_OPT_ID PAR_OPT_ID
FROM "BEN"."BEN_COMP_OBJ_CACHE_ROW"