Line 483: 'select mrp_form_query_s.nextval'||p_dblink||
479: l_supplier is not null) or
480: (p_load_type = PURCHASE_REQ_RESCHEDULE and
481: l_buyer is not null) then
482: lv_sql_stmt:= 483: 'select mrp_form_query_s.nextval'||p_dblink|| 484: ' from dual';
485:
486: OPEN poCur FOR lv_sql_stmt;
487: FETCH poCur INTO p_query_id;
Line 3468: select to_char(mrp_form_query_s.nextval)
3464: LOOP
3465: FETCH all_c INTO all_rec;
3466: EXIT WHEN all_c%NOTFOUND;
3467: 3468: select to_char(mrp_form_query_s.nextval) 3469: into item_key
3470: from dual;
3471:
3472: OPEN PLANNER_C(all_rec.plan_id,