APPS.GME_CONVERT_FPO_PVT dependencies on GMD_RECIPE_VALIDITY_RULES

Line 208: FROM gmd_recipe_validity_rules

204: WHERE batch_id = v_batch_id
205: AND line_type = 1
206: AND inventory_item_id =
207: (SELECT inventory_item_id
208: FROM gmd_recipe_validity_rules
209: WHERE recipe_validity_rule_id =
210: (SELECT recipe_validity_rule_id
211: FROM gme_batch_header
212: WHERE batch_id = v_batch_id) );

Line 845: --Remember that organization_id can be null in gmd_recipe_validity_rules

841:
842:
843: /* Cusror definitions */
844: --KYH GME Convergence - replace ic_item_mst with mtl_system_items
845: --Remember that organization_id can be null in gmd_recipe_validity_rules
846: Cursor get_validity_rule (v_validity_rule_id NUMBER,v_organization_id NUMBER) IS
847: SELECT v.inventory_item_id, i.primary_uom_code
848: FROM gmd_recipe_validity_rules v, mtl_system_items i
849: WHERE recipe_validity_rule_id = v_validity_rule_id

Line 848: FROM gmd_recipe_validity_rules v, mtl_system_items i

844: --KYH GME Convergence - replace ic_item_mst with mtl_system_items
845: --Remember that organization_id can be null in gmd_recipe_validity_rules
846: Cursor get_validity_rule (v_validity_rule_id NUMBER,v_organization_id NUMBER) IS
847: SELECT v.inventory_item_id, i.primary_uom_code
848: FROM gmd_recipe_validity_rules v, mtl_system_items i
849: WHERE recipe_validity_rule_id = v_validity_rule_id
850: AND i.organization_id = v_organization_id
851: AND v.inventory_item_id = i.inventory_item_id;
852: BEGIN

Line 1501: FROM gmd_recipe_validity_rules v, mtl_system_items i

1497: /* Cursor definitions */
1498: --KYH GME Convergence - replace ic_item_mst with mtl_system_items
1499: Cursor get_validity_rule (v_validity_rule_id NUMBER, v_organization_id NUMBER) IS
1500: SELECT v.inventory_item_id, i.primary_uom_code
1501: FROM gmd_recipe_validity_rules v, mtl_system_items i
1502: WHERE recipe_validity_rule_id = v_validity_rule_id
1503: AND i.organization_id = v_organization_id
1504: AND v.inventory_item_id = i.inventory_item_id;
1505: