OPM Class Extraction Script

 /* Cost Component Class*/
SELECT   cost_cmpntcls_code, cmpnt_group, cost_cmpntcls_desc
    FROM cm_cmpt_mst_vl
   --WHERE cost_cmpntcls_code LIKE 'OSD2%'
ORDER BY 1

/*  Activity Class */
SELECT   activity, activity_desc
    FROM gmd_activities_vl
ORDER BY 1

/* Resource Class*/
SELECT   resource_class, resource_class_desc
    FROM cr_rsrc_cls_vl
ORDER BY 1

/* Operation Class */
SELECT   oprn_class operation_class, oprn_class_desc
    FROM fm_oprn_cls
ORDER BY 1

/* Routing Class */
SELECT   routing_class, routing_class_desc
    FROM fm_rout_cls
ORDER BY 1

/* Formula Class */
SELECT   formula_class, formula_class_desc
    FROM fm_form_cls
ORDER BY 1

/* Alternate Resource*/
SELECT   crm.resources primary_resource,
         crm.resource_desc primary_resource_desc, cam.alternate_resource,
         cam.runtime_factor, cam.preference, msi.segment1 item_code,
         msi.description item_description
    FROM cr_rsrc_mst crm,
         cr_ares_mst cam,
         gmp_altresource_products gap,
         (SELECT inventory_item_id, segment1, description
            FROM mtl_system_items_b
           WHERE enabled_flag = 'Y' AND organization_id = 1823   -- MASTER ORG 
                                                              ) msi
   WHERE -1 = -1
     AND crm.resources = cam.primary_resource
     AND crm.resources = gap.primary_resource
     AND cam.alternate_resource = gap.alternate_resource
     AND msi.inventory_item_id = gap.inventory_item_id
ORDER BY 1