Product: | GMD - Process Manufacturing Product Development |
---|---|
Description: | This view is used to retrieve Step information to generate Master Batch Record XML |
Implementation/DBA Data: | APPS.GMD_MBR_STEP_OPRN_V1 |
SELECT ROUT_DTL.ROUTING_ID
, ROUT_DTL.ROUTINGSTEP_NO
, ROUT_DTL.ROUTINGSTEP_ID
, ROUT_DTL.OPRN_ID
, ROUT_DTL.STEP_QTY
, ROUT_DTL.STEPRELEASE_TYPE
, ROUT_DTL.MINIMUM_TRANSFER_QTY
, OPRN.OPRN_NO
, OPRN.OPRN_VERS
, OPRN.PROCESS_QTY_UOM
, OPRN.OPRN_CLASS
, OPRN.INACTIVE_IND
, FND_DATE.DATE_TO_DISPLAYDT(OPRN.EFFECTIVE_START_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, FND_DATE.DATE_TO_DISPLAYDT(OPRN.EFFECTIVE_END_DATE
, FND_TIMEZONES.GET_SERVER_TIMEZONE_CODE)
, OPRN.OPERATION_STATUS
, OPRN.OWNER_ORGANIZATION_ID
, OPRN.OPRN_DESC
, RCP.RECIPE_ID
, RCP.RECIPE_ID||'$'||ROUT_DTL.ROUTINGSTEP_ID||'$'||ROUT_DTL.OPRN_ID
FROM GMD_RECIPES_B RCP
, FM_ROUT_DTL ROUT_DTL
, GMD_OPERATIONS OPRN
WHERE ROUT_DTL.OPRN_ID = OPRN.OPRN_ID
AND RCP.ROUTING_ID = ROUT_DTL.ROUTING_ID ORDER BY ROUT_DTL.ROUTINGSTEP_NO