Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | This view is used to retrieve Resource Requirements Information for Master Batch Record XML generation. |
Implementation/DBA Data: | APPS.GMD_MBR_RECIPE_RSRC_V1 |
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