VIEW: APPS.PJI_MT_MEASURES_V

Source

View Text - Preformatted

SELECT mss.MEASURE_SET_CODE measure_set_code , mss.MEASURE_SET_TYPE measure_set_type , mss.MEASURE_FORMAT measure_format , mss.DB_COLUMN_NAME db_column_name , mss.NAME measure_set_name , mss.DESCRIPTION measure_set_description , msr.MEASURE_ID measure_id , msr.MEASURE_SET_CODE measure_set_cdoe , msr.MEASURE_CODE measure_code , msr.XTD_TYPE xtd_type , msr.PL_SQL_API pl_sql_api , msr.NAME measure_name , msr.DESCRIPTION measure_description FROM pji_mt_measures_vl msr , pji_mt_measure_sets_vl mss WHERE msr.measure_set_code = mss.measure_set_code

View Text - HTML Formatted

SELECT MSS.MEASURE_SET_CODE MEASURE_SET_CODE
, MSS.MEASURE_SET_TYPE MEASURE_SET_TYPE
, MSS.MEASURE_FORMAT MEASURE_FORMAT
, MSS.DB_COLUMN_NAME DB_COLUMN_NAME
, MSS.NAME MEASURE_SET_NAME
, MSS.DESCRIPTION MEASURE_SET_DESCRIPTION
, MSR.MEASURE_ID MEASURE_ID
, MSR.MEASURE_SET_CODE MEASURE_SET_CDOE
, MSR.MEASURE_CODE MEASURE_CODE
, MSR.XTD_TYPE XTD_TYPE
, MSR.PL_SQL_API PL_SQL_API
, MSR.NAME MEASURE_NAME
, MSR.DESCRIPTION MEASURE_DESCRIPTION
FROM PJI_MT_MEASURES_VL MSR
, PJI_MT_MEASURE_SETS_VL MSS
WHERE MSR.MEASURE_SET_CODE = MSS.MEASURE_SET_CODE