933: SELECT gem5_formulaline_id_s.NEXTVAL
934: FROM dual;
935:
936: CURSOR Cur_spreadline_id IS
937: SELECT gem5_sprd_line_id_s.nextval
938: FROM dual;
939:
940: CURSOR Cur_get_materials (Pline_id NUMBER) IS
941: SELECT *
1248: SELECT gem5_sprd_id_s.nextval
1249: FROM fnd_dual;
1250:
1251: CURSOR Cur_line_id IS
1252: SELECT gem5_sprd_line_id_s.nextval
1253: FROM fnd_dual;
1254:
1255: CURSOR Cur_sprd_insert IS
1256: SELECT line_id,V_orgn_id,move_order_line_id,line_type,formulaline_id,