DBA Data[Home] [Help]

APPS.GMD_LCF_FETCH_PKG dependencies on MTL_SYSTEM_ITEMS_KFV

Line 227: FROM mtl_system_items_kfv

223: WHERE line_id = V_line_id;
224:
225: CURSOR Cur_line_item_number (V_inventory_item_id NUMBER)IS
226: SELECT concatenated_segments
227: FROM mtl_system_items_kfv
228: WHERE inventory_item_id = V_inventory_item_id;
229:
230: l_conv_factor NUMBER;
231: l_mass_qty NUMBER;

Line 574: FROM gmd_material_details_gtmp a, mtl_system_items_kfv b

570: PROCEDURE load_items (V_formulation_spec_id IN NUMBER, V_organization_id IN NUMBER,V_ingred_pick_base IN VARCHAR2,
571: V_formula_no IN VARCHAR2, V_batch_no IN VARCHAR2,V_date IN DATE) IS
572: CURSOR Cur_get_sim_material IS
573: SELECT a.*, b.concatenated_segments item
574: FROM gmd_material_details_gtmp a, mtl_system_items_kfv b
575: WHERE line_type = -1
576: AND a.inventory_item_id = b.inventory_item_id
577: AND b.organization_id = V_organization_id;
578:

Line 586: FROM gmd_material_reqs a, mtl_system_items_kfv b

582: WHERE formulation_spec_id = V_formulation_spec_id;
583:
584: CURSOR Cur_get_formula IS
585: SELECT a.*, b.concatenated_segments, b.description, b.primary_uom_code
586: FROM gmd_material_reqs a, mtl_system_items_kfv b
587: WHERE formulation_spec_id = V_formulation_spec_id
588: AND a.inventory_item_id = b.inventory_item_id
589: AND b.organization_id = V_organization_id
590: ORDER BY b.concatenated_segments;

Line 595: FROM mtl_system_items_kfv b

591:
592: CURSOR Cur_get_comp IS
593: SELECT b.concatenated_segments, b.inventory_item_id,
594: b.description, b.primary_uom_code
595: FROM mtl_system_items_kfv b
596: WHERE EXISTS (SELECT 1
597: FROM gmd_lcf_category_hdr_gtmp a, mtl_item_categories c
598: WHERE a.category_set_id = c.category_set_id
599: AND a.category_id = c.category_id