APPS.GMD_COA_DATA_NEW dependencies on IC_TRAN_PND

Line 1432: CURSOR get_lot_tran (c_line_id ic_tran_pnd.line_id%TYPE) IS

1428: whse_code = c_whse_code
1429: and delete_mark = 0
1430: ;
1431:
1432: CURSOR get_lot_tran (c_line_id ic_tran_pnd.line_id%TYPE) IS
1433: SELECT itp.lot_id, itp.whse_code, itp.location
1434: FROM
1435: ic_tran_pnd itp
1436: WHERE

Line 1435: ic_tran_pnd itp

1431:
1432: CURSOR get_lot_tran (c_line_id ic_tran_pnd.line_id%TYPE) IS
1433: SELECT itp.lot_id, itp.whse_code, itp.location
1434: FROM
1435: ic_tran_pnd itp
1436: WHERE
1437: itp.doc_type = 'OPSO'
1438: AND itp.completed_ind <> -1
1439: AND itp.line_id = c_line_id

Line 1692: /* get lot id from ic_tran_pnd */

1688: END IF;
1689: /* end if generic_id has a value */
1690: /* fill in whse, customer name, bol no at end of code */
1691:
1692: /* get lot id from ic_tran_pnd */
1693: /* get lot no and name and sublot no from ic_lot_mst at end of code */
1694: /* (2 steps so non-sales-order loop can also use get_lot_info) */
1695:
1696: IF ord_cur_rec.alloc_qty > 0 THEN

Line 1700: /* end getting lot id from ic_tran_pnd */

1696: IF ord_cur_rec.alloc_qty > 0 THEN
1697: FOR lot_cur_rec IN get_lot_tran (ord_cur_rec.line_id) LOOP
1698: tbl_hdr(tbl_ndx).lot_id := lot_cur_rec.lot_id;
1699: END LOOP;
1700: /* end getting lot id from ic_tran_pnd */
1701: END IF;
1702: /* end checking if alloc qty > 0 */
1703: /* report title = COA or COC */
1704: tbl_hdr(tbl_ndx).report_title := v_report_title;