903: SELECT gem5_formulaline_id_s.NEXTVAL
904: FROM dual;
905:
906: CURSOR Cur_spreadline_id IS
907: SELECT gem5_sprd_line_id_s.nextval
908: FROM dual;
909:
910: CURSOR Cur_get_materials (Pline_id NUMBER) IS
911: SELECT *
1214: SELECT gem5_sprd_id_s.nextval
1215: FROM fnd_dual;
1216:
1217: CURSOR Cur_line_id IS
1218: SELECT gem5_sprd_line_id_s.nextval
1219: FROM fnd_dual;
1220:
1221: CURSOR Cur_sprd_insert IS
1222: SELECT line_id,V_orgn_id,move_order_line_id,line_type,formulaline_id,