APPS.GMD_COA_DATA_NEW dependencies on OP_GNRC_ITM

Line 1388: CURSOR get_gnrc_info (c_generic_id op_gnrc_itm.generic_id%TYPE) IS

1384: and ood.delete_mark = 0
1385: ;
1386:
1387:
1388: CURSOR get_gnrc_info (c_generic_id op_gnrc_itm.generic_id%TYPE) IS
1389: SELECT generic_item,
1390: generic_desc
1391: FROM
1392: op_gnrc_itm

Line 1392: op_gnrc_itm

1388: CURSOR get_gnrc_info (c_generic_id op_gnrc_itm.generic_id%TYPE) IS
1389: SELECT generic_item,
1390: generic_desc
1391: FROM
1392: op_gnrc_itm
1393: WHERE generic_id = c_generic_id
1394: and delete_mark = 0
1395: ;
1396:

Line 1674: /* from op_gnrc_itm, else get item no and desc from ic_item_mst */

1670: tbl_hdr(tbl_ndx).shipdate := ord_cur_rec.actual_shipdate;
1671: END IF;
1672:
1673: /* if generic id exists in sales order record, get item no and desc */
1674: /* from op_gnrc_itm, else get item no and desc from ic_item_mst */
1675:
1676: IF ord_cur_rec.generic_id is not NULL THEN
1677: FOR gnrc_cur_rec IN get_gnrc_info (ord_cur_rec.generic_id) LOOP
1678: tbl_hdr(tbl_ndx).item_no := gnrc_cur_rec.generic_item;