APPS.GML_PO_SYNCH dependencies on GEM5_SUMM_INV_ID_S
Line 2614: select gem5_summ_inv_id_s.nextval into l_iret from dual;
2610: If there is no entry for the item/warehouse/qc grade combn
2611: in ic_summ_inv table then insert a row in it.*/
2612: IF (SQL%ROWCOUNT = 0) THEN
2613: /* Get the next sequence number */ 2614: select gem5_summ_inv_id_s.nextval into l_iret from dual; 2615:
2616: /* Since a row for this item does not already exists enter a row */
2617: INSERT INTO ic_summ_inv
2618: (summ_inv_id, item_id, whse_code, qc_grade,