514: ) RETURN VARCHAR2 IS
515:
516: CURSOR Cur_get_line_qty (V_line_id NUMBER) IS
517: SELECT qty_mass, qty_vol
518: FROM gmd_material_details_gtmp
519: WHERE line_id = V_line_id;
520:
521: CURSOR Cur_value (V_line_id NUMBER, V_parameter VARCHAR2) IS
522: SELECT value
580:
581:
582: CURSOR Cur_get_line (V_line_type NUMBER) IS
583: SELECT line_id
584: FROM gmd_material_details_gtmp a
585: WHERE entity_id = p_entity_id
586: AND rollup_ind = 1
587: AND EXISTS (SELECT 1
588: FROM gmd_material_details_gtmp b
584: FROM gmd_material_details_gtmp a
585: WHERE entity_id = p_entity_id
586: AND rollup_ind = 1
587: AND EXISTS (SELECT 1
588: FROM gmd_material_details_gtmp b
589: WHERE line_type = V_line_type
590: AND entity_id = p_entity_id
591: AND a.parent_line_id = b.parent_line_id);
592: