APPS.GMD_LCF_FETCH_PKG dependencies on GMD_MATERIAL_REQS

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 934: FROM gmd_material_reqs a, gmd_lcf_details_gtmp b

930: --Get the material requirements defined for particular formulation specification.
931: CURSOR Cur_get_matl_req IS
932: SELECT a.inventory_item_id, a.min_qty, a.max_qty,
933: a.item_uom, a.range_type, b.concatenated_segments
934: FROM gmd_material_reqs a, gmd_lcf_details_gtmp b
935: WHERE (a.min_qty IS NOT NULL OR a.max_qty IS NOT NULL)
936: AND a.formulation_spec_id = V_formulation_spec_id
937: AND a.inventory_item_id = b.inventory_item_id
938: ORDER BY b.line_id;