DBA Data[Home] [Help]

APPS.GMD_RECIPE_DETAIL dependencies on GMD_RECIPE_ORGN_RESOURCES

Line 2960: From gmd_recipe_orgn_resources

2956: attribute11, attribute12, attribute13, attribute14, attribute15,
2957: attribute16, attribute17, attribute18, attribute19, attribute20,
2958: attribute21, attribute22, attribute23, attribute24,attribute25,
2959: attribute26, attribute27, attribute28, attribute29, attribute30
2960: From gmd_recipe_orgn_resources
2961: where recipe_id = NVL(vRecipe_id,-1) AND
2962: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
2963: oprn_line_id = NVL(vOprn_line_id,-1) AND
2964: resources = vResources AND

Line 2971: From gmd_recipe_orgn_resources

2967: CURSOR update_res_cur(vRecipe_id NUMBER, vRoutingStep_id NUMBER,
2968: vOprn_line_id NUMBER, vResources VARCHAR2, vOrgn_id NUMBER) IS
2969: Select min_capacity, max_capacity, process_qty, usage_uom,
2970: resource_usage
2971: From gmd_recipe_orgn_resources
2972: where recipe_id = NVL(vRecipe_id,-1) AND
2973: RoutingStep_id = NVL(vRoutingStep_id,-1) AND
2974: oprn_line_id = NVL(vOprn_line_id,-1) AND
2975: resources = vResources AND

Line 2981: /* gmd_recipe_orgn_resources table */

2977:
2978: setup_failure EXCEPTION;
2979: BEGIN
2980: /* Updating recipe orgn resources for forst time infact insert a new record in */
2981: /* gmd_recipe_orgn_resources table */
2982:
2983: /* Define Savepoint */
2984: SAVEPOINT Recipe_Orgn_Resources;
2985: