DBA Data[Home] [Help]

APPS.GMD_LCF_FETCH_PKG dependencies on GMD_MATERIAL_DETAILS_GTMP

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: