APPS.GME_GMEMUSBV_XMLP_PKG dependencies on GMD_RECIPE_VALIDITY_RULES

Line 226: GMD_RECIPE_VALIDITY_RULES

222: AND INVENTORY_ITEM_ID = (
223: SELECT
224: INVENTORY_ITEM_ID
225: FROM
226: GMD_RECIPE_VALIDITY_RULES
227: WHERE RECIPE_VALIDITY_RULE_ID = CF_BATCH_SIZEFORMULA.RECIPE_VALIDITY_RULE_ID );
228: ELSE
229: SELECT
230: PLAN_QTY

Line 260: GMD_RECIPE_VALIDITY_RULES

256: AND INVENTORY_ITEM_ID = (
257: SELECT
258: INVENTORY_ITEM_ID
259: FROM
260: GMD_RECIPE_VALIDITY_RULES
261: WHERE RECIPE_VALIDITY_RULE_ID = cf_itemumformula.RECIPE_VALIDITY_RULE_ID );
262: ELSE
263: SELECT
264: DTL_UM

Line 312: GMD_RECIPE_VALIDITY_RULES

308: CURSOR CUR_PRIMARY_PROD IS
309: SELECT
310: INVENTORY_ITEM_ID
311: FROM
312: GMD_RECIPE_VALIDITY_RULES
313: WHERE RECIPE_VALIDITY_RULE_ID = trans_qtyformula_005.RECIPE_VALIDITY_RULE_ID;
314: CURSOR CUR_ITEM_UM(V_ITEM_ID IN NUMBER) IS
315: SELECT
316: PRIMARY_UOM_CODE

Line 362: GMD_RECIPE_VALIDITY_RULES A

358: B.FORMULA_ID,
359: B.PLAN_START_DATE
360: FROM
361: GME_BATCH_HEADER B,
362: GMD_RECIPE_VALIDITY_RULES A
363: WHERE B.BATCH_ID = PBATCH_ID
364: AND B.RECIPE_VALIDITY_RULE_ID = A.RECIPE_VALIDITY_RULE_ID;
365: CURSOR CUR_GET_RT_UOM(P_ROUTING_ID IN NUMBER) IS
366: SELECT