[Home] [Help]
1551: --| Kishore - 30-Sep-2008 - Bug No.7419838 |
1552: --| Changed the cursor c_orgn_plant, as Spec VR can be created for plant also |
1553: --|
1554: --| Michael Tou - 25-Aug-2011 - Bug No. 6278463 |
1555: --| Implemented outer-join on all the columns of gmd_routings table |
1556: --| in the cursors c_recipe_id , c_recipe_no, c_batch, c_routing_id and c_routing_no |
1557: --| PLOWE 05-OCT-2011 Bug # 13027522 |
1558: --| Changed the c_batch cursor to tidy up work for
1559: --| bug 6278463 as this was not working for when no route was passed thru API params |
1605: , gmd_recipe_validity_rules rvr
1606: , gmd_status gs
1607: , fm_matl_dtl fmd
1608: , fm_form_mst_b ffm -- just need base table here not view
1609: , gmd_routings_b rout -- just need base table here not view
1610: WHERE rout.routing_id(+) = bh.routing_id
1611: AND rvr.recipe_validity_rule_id = bh.recipe_validity_rule_id
1612: AND rvr.recipe_id = gr.recipe_id
1613: AND ffm.formula_id = bh.formula_id
1648: , rout.routing_id, rout.routing_no, rout.routing_vers
1649: FROM gmd_recipes r
1650: , gmd_status s
1651: , gmd_recipe_validity_rules rvr
1652: , gmd_routings rout
1653: , fm_form_mst ffm
1654: , fm_matl_dtl fmd
1655: WHERE rout.routing_id(+) = r.routing_id
1656: AND ffm.formula_id = r.formula_id
1675: SELECT r.recipe_id, r.recipe_version
1676: FROM gmd_recipes r
1677: , gmd_status s
1678: , gmd_recipe_validity_rules rvr
1679: , gmd_routings rout
1680: , fm_form_mst ffm
1681: , fm_matl_dtl fmd
1682: WHERE rout.routing_id(+) = r.routing_id
1683: AND ffm.formula_id = r.formula_id
1762: CURSOR c_routing_id IS
1763: SELECT r.routing_no, r.routing_vers
1764: FROM gmd_recipes grec
1765: , gmd_status s
1766: , gmd_routings r
1767: WHERE grec.routing_id(+) = r.routing_id
1768: AND s.status_code = r.routing_status
1769: AND NVL( l_wip_vr.recipe_id, 0) = grec.recipe_id(+) /*changed in bug# 6278463 */
1770: AND NVL( l_wip_vr.formula_id, 0) = grec.formula_id(+) /*changed in bug# 6278463 */
1776: CURSOR c_routing_no IS
1777: SELECT r.routing_id, r.routing_vers
1778: FROM gmd_recipes grec
1779: , gmd_status s
1780: , gmd_routings r
1781: WHERE grec.routing_id(+) = r.routing_id
1782: AND s.status_code = r.routing_status
1783: AND NVL( l_wip_vr.recipe_id, 0) = grec.recipe_id(+) /*changed in bug# 6278463 */
1784: AND NVL( l_wip_vr.formula_id, 0) = grec.formula_id(+) /*changed in bug# 6278463 */
1879: l_recipe_version GMD_RECIPES.RECIPE_VERSION%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1887: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1880: l_formula_id FM_FORM_MST.FORMULA_ID%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1887: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1888: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1881: l_formula_no FM_FORM_MST.FORMULA_NO%TYPE;
1882: l_formula_vers FM_FORM_MST.FORMULA_VERS%TYPE;
1883: l_routing_id GMD_ROUTINGS.ROUTING_ID%TYPE;
1884: l_routing_no GMD_ROUTINGS.ROUTING_NO%TYPE;
1885: l_routing_vers GMD_ROUTINGS.ROUTING_VERS%TYPE;
1886: l_step_no GMD_WIP_SPEC_VRS.STEP_NO%TYPE;
1887: l_oprn_no GMD_OPERATIONS.OPRN_NO%TYPE;
1888: l_oprn_vers GMD_OPERATIONS.OPRN_VERS%TYPE;
1889: l_sample_display GMD_SAMPLES_GRP.sample_display_rec;