eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_STATUS_PUB dependencies on GMD_RECIPE_VALIDITY_RULES

Line 190: FROM gmd_recipe_validity_rules

186: -- Gets the validity rule details and its current status code
187: -- Bug 5347418 added recipe_use
188: CURSOR get_curr_vr_status(vVR_id NUMBER) IS
189: SELECT recipe_validity_rule_id, validity_rule_status, recipe_use
190: FROM gmd_recipe_validity_rules
191: WHERE recipe_validity_rule_id = vVR_id;
192:
193: -- Bug 5394532
194: -- Gets the substitution details and its current status code

Line 208: FROM gmd_recipes r, gmd_recipe_validity_rules vr

204:
205: -- Gets the formula associated with the val rule
206: CURSOR get_vr_dets(vVR_id NUMBER) IS
207: SELECT r.formula_id, vr.organization_id
208: FROM gmd_recipes r, gmd_recipe_validity_rules vr
209: WHERE r.recipe_id = vr.recipe_id
210: AND vr.recipe_validity_rule_id = vVR_id;
211:
212: -- Recipe being changed to ON-HOLD - check for less than ON-HOLD and FROZEN

Line 217: FROM gmd_status s, gmd_recipe_validity_rules v

213: Cursor check_val_rules_800(vEntity_id NUMBER) IS
214: SELECT 1 from sys.dual
215: WHERE EXISTS (
216: SELECT recipe_validity_rule_id
217: FROM gmd_status s, gmd_recipe_validity_rules v
218: WHERE recipe_id = vEntity_id
219: AND v.validity_rule_status = s.status_code
220: AND (to_number(s.status_type) < to_number('800')
221: OR s.status_type = '900') );

Line 228: FROM gmd_status s, gmd_recipe_validity_rules v

224: Cursor check_val_rules_900(vEntity_id NUMBER) IS
225: SELECT 1 from sys.dual
226: WHERE EXISTS (
227: SELECT recipe_validity_rule_id
228: FROM gmd_status s, gmd_recipe_validity_rules v
229: WHERE recipe_id = vEntity_id
230: AND v.validity_rule_status = s.status_code
231: AND to_number(s.status_type) < to_number('800') );
232:

Line 238: FROM gmd_status s, gmd_recipe_validity_rules v

234: Cursor check_val_rules_1000(vEntity_id NUMBER) IS
235: SELECT 1 from sys.dual
236: WHERE EXISTS (
237: SELECT recipe_validity_rule_id
238: FROM gmd_status s, gmd_recipe_validity_rules v
239: WHERE recipe_id = vEntity_id
240: AND v.validity_rule_status = s.status_code
241: AND to_number(s.status_type) < to_number('1000') );
242:

Line 255: FROM mtl_system_items i, gmd_recipe_validity_rules v

251: CURSOR Cur_chk_prod_exec_enabled (V_val_rule_id NUMBER) IS
252: -- Get process ececution enabled setting for the val rule orgn
253: -- (Local val rules)
254: SELECT i.process_execution_enabled_flag
255: FROM mtl_system_items i, gmd_recipe_validity_rules v
256: WHERE v.recipe_validity_rule_id = V_val_rule_id
257: AND i.inventory_item_id = v.inventory_item_id
258: AND i.organization_id = v.organization_id
259: AND v.organization_id IS NOT NULL

Line 264: FROM mtl_system_items i, gmd_recipe_validity_rules v, gmd_recipes_b re

260: UNION
261: -- Get process ececution enabled setting for the recipe owning orgn
262: -- for Global recipes (Global val rules)
263: SELECT i.process_execution_enabled_flag
264: FROM mtl_system_items i, gmd_recipe_validity_rules v, gmd_recipes_b re
265: WHERE v.recipe_validity_rule_id = V_val_rule_id
266: AND i.inventory_item_id = v.inventory_item_id
267: AND v.recipe_id = re.recipe_id
268: AND i.organization_id = re.owner_organization_id

Line 726: UPDATE gmd_recipe_validity_rules

722: IF (p_ignore_flag) THEN
723: -- Now update the VR according to recipe status change
724: IF (to_number(l_to_status_type) = 800) THEN
725: -- Change status to ON-HOLD for less than ON-HOLD
726: UPDATE gmd_recipe_validity_rules
727: SET validity_rule_status = P_to_status
728: WHERE recipe_id = l_entity_id
729: AND (to_number(validity_rule_status) < to_number('800') OR
730: to_number(validity_rule_status) between 900 and 999);

Line 732: UPDATE gmd_recipe_validity_rules

728: WHERE recipe_id = l_entity_id
729: AND (to_number(validity_rule_status) < to_number('800') OR
730: to_number(validity_rule_status) between 900 and 999);
731: ELSIF (to_number(l_to_status_type) = 900) THEN
732: UPDATE gmd_recipe_validity_rules
733: SET validity_rule_status = P_to_status
734: WHERE recipe_id = l_entity_id
735: AND to_number(validity_rule_status) < to_number('800') ;
736: ELSIF (to_number(l_to_status_type) = 1000) THEN

Line 740: UPDATE gmd_recipe_validity_rules

736: ELSIF (to_number(l_to_status_type) = 1000) THEN
737: IF (l_debug = 'Y') THEN
738: gmd_debug.put_line('Ignore flag was true and we are about update VR ');
739: END IF;
740: UPDATE gmd_recipe_validity_rules
741: SET validity_rule_status = P_to_status
742: WHERE recipe_id = l_entity_id
743: AND to_number(validity_rule_status) < to_number('1000') ;
744: END IF;

Line 942: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name

938: 'FORMULA','FM_FORM_MST_B',
939: 'RECIPE','GMD_RECIPES_B',
940: 'OPERATION','GMD_OPERATIONS_B',
941: 'ROUTING','GMD_ROUTINGS_B',
942: 'VALIDITY','GMD_RECIPE_VALIDITY_RULES') INTO l_table_name
943: FROM sys.dual;
944: gmd_api_grp.log_message('GMD_RECORD_LOCKED',
945: 'TABLE_NAME',l_table_name,
946: 'KEY',NVL(p_entity_id, l_entity_id)