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 779: --Remember that organization_id can be null in gmd_recipe_validity_rules

775:
776:
777: /* Cusror definitions */
778: --KYH GME Convergence - replace ic_item_mst with mtl_system_items
779: --Remember that organization_id can be null in gmd_recipe_validity_rules
780: Cursor get_validity_rule (v_validity_rule_id NUMBER,v_organization_id NUMBER) IS
781: SELECT v.inventory_item_id, i.primary_uom_code
782: FROM gmd_recipe_validity_rules v, mtl_system_items i
783: WHERE recipe_validity_rule_id = v_validity_rule_id

Line 782: FROM gmd_recipe_validity_rules v, mtl_system_items i

778: --KYH GME Convergence - replace ic_item_mst with mtl_system_items
779: --Remember that organization_id can be null in gmd_recipe_validity_rules
780: Cursor get_validity_rule (v_validity_rule_id NUMBER,v_organization_id NUMBER) IS
781: SELECT v.inventory_item_id, i.primary_uom_code
782: FROM gmd_recipe_validity_rules v, mtl_system_items i
783: WHERE recipe_validity_rule_id = v_validity_rule_id
784: AND i.organization_id = v_organization_id
785: AND v.inventory_item_id = i.inventory_item_id;
786: BEGIN

Line 1398: FROM gmd_recipe_validity_rules v, mtl_system_items i

1394: /* Cursor definitions */
1395: --KYH GME Convergence - replace ic_item_mst with mtl_system_items
1396: Cursor get_validity_rule (v_validity_rule_id NUMBER, v_organization_id NUMBER) IS
1397: SELECT v.inventory_item_id, i.primary_uom_code
1398: FROM gmd_recipe_validity_rules v, mtl_system_items i
1399: WHERE recipe_validity_rule_id = v_validity_rule_id
1400: AND i.organization_id = v_organization_id
1401: AND v.inventory_item_id = i.inventory_item_id;
1402: