VIEW: SYS.KU$_RMGR_PLAN_VIEW

Source

View Text - Preformatted

select '1','0',
        r.obj#,
        (select value(o) from  sys.ku$_schemaobj_view o where
             o.obj_num=r.obj#),
        r.mgmt_method, r.mast_method,
        r.pdl_method, r.num_plan_directives,
        r.description,  r.que_method,
        r.status, r.mandatory
  from resource_plan$ r

View Text - HTML Formatted

SELECT '1'
, '0'
, R.OBJ#
, (SELECT VALUE(O)
FROM SYS.KU$_SCHEMAOBJ_VIEW O WHERE O.OBJ_NUM=R.OBJ#)
, R.MGMT_METHOD
, R.MAST_METHOD
, R.PDL_METHOD
, R.NUM_PLAN_DIRECTIVES
, R.DESCRIPTION
, R.QUE_METHOD
, R.STATUS
, R.MANDATORY
FROM RESOURCE_PLAN$ R