DBA Data[Home] [Help]

APPS.GME_POST_MIGRATION dependencies on GMD_RECIPE_VALIDITY_RULES

Line 123: FROM gmd_recipe_validity_rules

119:
120: -- Bug 13706812/13839066 - Let's make sure we update primary_item_id.
121: CURSOR Cur_get_prim_item(v_recipe_validity_rule_id NUMBER, v_organization_id NUMBER) IS
122: SELECT inventory_item_id
123: FROM gmd_recipe_validity_rules
124: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id
125: AND organization_id = v_organization_id
126: AND ROWNUM = 1;
127:

Line 131: FROM gmd_recipe_validity_rules

127:
128: -- Bug 13996808 - Let's check null org.
129: CURSOR Cur_get_prim_item_null(v_recipe_validity_rule_id NUMBER) IS
130: SELECT inventory_item_id
131: FROM gmd_recipe_validity_rules
132: WHERE recipe_validity_rule_id = v_recipe_validity_rule_id
133: AND organization_id IS NULL
134: AND ROWNUM = 1;
135: