DBA Data[Home] [Help]

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,