DBA Data[Home] [Help]

APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 3087: From gmd_recipe_orgn_resources

3083: attribute11, attribute12, attribute13, attribute14, attribute15,
3084: attribute16, attribute17, attribute18, attribute19, attribute20,
3085: attribute21, attribute22, attribute23, attribute24,attribute25,
3086: attribute26, attribute27, attribute28, attribute29, attribute30
3087: From gmd_recipe_orgn_resources
3088: where recipe_id = NVL(vRecipe_id,-1) AND
3089: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
3090: oprn_line_id = NVL(vOprn_line_id,-1) AND
3091: resources = vResources AND

Line 3098: From gmd_recipe_orgn_resources

3094: CURSOR update_res_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER,
3095: vOprn_line_id NUMBER, vResources VARCHAR2, vOrgn_id NUMBER) IS
3096: Select min_capacity, max_capacity, process_qty, usage_uom,
3097: resource_usage
3098: From gmd_recipe_orgn_resources
3099: where recipe_id = NVL(vRecipe_id,-1) AND
3100: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
3101: oprn_line_id = NVL(vOprn_line_id,-1) AND
3102: resources = vResources AND

Line 3123: /* gmd_recipe_orgn_resources table */

3119:
3120:
3121: BEGIN
3122: /* Updating recipe orgn resources for forst time infact insert a new record in */
3123: /* gmd_recipe_orgn_resources table */
3124:
3125: /* Define Savepoint */
3126: SAVEPOINT Recipe_Orgn_Resources;
3127: