VIEW: SYS.DBA_RSRC_PLANS

Source

View Text - Preformatted

select obj#,name,num_plan_directives,mgmt_method,mgmt_method,mast_method,
       pdl_method,que_method,
       decode(sub_plan,1,'YES','NO'),
       description,
       decode(status,'ACTIVE',NULL,status),
       decode(mandatory,1,'YES','NO')
from resource_plan$
where sys_context('userenv', 'con_id') <> 1
order by status

View Text - HTML Formatted

SELECT OBJ#
, NAME
, NUM_PLAN_DIRECTIVES
, MGMT_METHOD
, MGMT_METHOD
, MAST_METHOD
, PDL_METHOD
, QUE_METHOD
, DECODE(SUB_PLAN
, 1
, 'YES'
, 'NO')
, DESCRIPTION
, DECODE(STATUS
, 'ACTIVE'
, NULL
, STATUS)
, DECODE(MANDATORY
, 1
, 'YES'
, 'NO') FROM RESOURCE_PLAN$ WHERE SYS_CONTEXT('USERENV'
, 'CON_ID') <> 1 ORDER BY STATUS