VIEW: APPS.GMD_MBR_RECIPE_RSRC_V1

Source

View Text - Preformatted

SELECT r.recipe_id , d.routingstep_id , d.routingstep_no routing_step_no, o.oprn_id, o.oprn_no, o.oprn_vers, o.oprn_desc, a.activity, res.oprn_line_id oprnline_id, res.resources, res.resource_usage, res.resource_count, res.process_qty, res.prim_rsrc_ind, res.scale_type, res.cost_analysis_code, res.cost_cmpntcls_id, res.resource_usage_uom usage_uom, res.offset_interval, m.max_capacity max_capacity, m.min_capacity min_capacity, m.capacity_um capacity_uom, res.resource_process_uom process_uom, r.recipe_id||'$'||d.routingstep_id||'$'||res.oprn_line_id||'$'||res.resources FROM gmd_recipes_b r, fm_rout_dtl d, gmd_operations_b o, gmd_operation_activities a, gmd_operation_resources res, cr_rsrc_mst_b m WHERE d.routing_id = r.routing_id AND d.oprn_id = o.oprn_id AND o.oprn_id = a.oprn_id AND a.oprn_line_id = res.oprn_line_id AND m.resources = res.resources ORDER BY routing_step_no, oprnline_id,resources

View Text - HTML Formatted

SELECT R.RECIPE_ID
, D.ROUTINGSTEP_ID
, D.ROUTINGSTEP_NO ROUTING_STEP_NO
, O.OPRN_ID
, O.OPRN_NO
, O.OPRN_VERS
, O.OPRN_DESC
, A.ACTIVITY
, RES.OPRN_LINE_ID OPRNLINE_ID
, RES.RESOURCES
, RES.RESOURCE_USAGE
, RES.RESOURCE_COUNT
, RES.PROCESS_QTY
, RES.PRIM_RSRC_IND
, RES.SCALE_TYPE
, RES.COST_ANALYSIS_CODE
, RES.COST_CMPNTCLS_ID
, RES.RESOURCE_USAGE_UOM USAGE_UOM
, RES.OFFSET_INTERVAL
, M.MAX_CAPACITY MAX_CAPACITY
, M.MIN_CAPACITY MIN_CAPACITY
, M.CAPACITY_UM CAPACITY_UOM
, RES.RESOURCE_PROCESS_UOM PROCESS_UOM
, R.RECIPE_ID||'$'||D.ROUTINGSTEP_ID||'$'||RES.OPRN_LINE_ID||'$'||RES.RESOURCES
FROM GMD_RECIPES_B R
, FM_ROUT_DTL D
, GMD_OPERATIONS_B O
, GMD_OPERATION_ACTIVITIES A
, GMD_OPERATION_RESOURCES RES
, CR_RSRC_MST_B M
WHERE D.ROUTING_ID = R.ROUTING_ID
AND D.OPRN_ID = O.OPRN_ID
AND O.OPRN_ID = A.OPRN_ID
AND A.OPRN_LINE_ID = RES.OPRN_LINE_ID
AND M.RESOURCES = RES.RESOURCES ORDER BY ROUTING_STEP_NO
, OPRNLINE_ID
, RESOURCES