APPS.GME_CONVERT_FPO_PVT dependencies on MTL_SYSTEM_ITEMS

Line 226: FROM mtl_system_items_kfv

222: --Susruth D. Bug#4917636 Start
223: CURSOR item_master_cursor (v_inventory_item_id NUMBER, v_org_id NUMBER)
224: IS
225: SELECT concatenated_segments,description
226: FROM mtl_system_items_kfv
227: WHERE inventory_item_id = v_inventory_item_id
228: AND organization_id = v_org_id;
229: /*SELECT *
230: FROM mtl_system_items_kfv

Line 230: FROM mtl_system_items_kfv

226: FROM mtl_system_items_kfv
227: WHERE inventory_item_id = v_inventory_item_id
228: AND organization_id = v_org_id;
229: /*SELECT *
230: FROM mtl_system_items_kfv
231: WHERE inventory_item_id = v_inventory_item_id
232: AND organization_id = v_org_id;*/
233: --Susruth D. Bug#4917636 End.
234: l_item_row item_master_cursor%ROWTYPE;

Line 240: FROM mtl_system_items_b

236: CURSOR get_production_rules (v_inventory_item_id NUMBER, v_org_id NUMBER)
237: IS
238: SELECT std_lot_size, primary_uom_code, fixed_lead_time
239: ,variable_lead_time
240: FROM mtl_system_items_b
241: WHERE inventory_item_id = v_inventory_item_id
242: AND organization_id = v_org_id;
243:
244: l_get_production_rules get_production_rules%ROWTYPE;

Line 778: --KYH GME Convergence - replace ic_item_mst with mtl_system_items

774: l_msg_data VARCHAR2(300);
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

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 1395: --KYH GME Convergence - replace ic_item_mst with mtl_system_items

1391: ,p_use_for_all IN VARCHAR2 := fnd_api.g_true)
1392: IS
1393: l_api_name CONSTANT VARCHAR2 (30) := 'CONVERT_FPO_MAIN';
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

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: