APPS.GMD_COA_DATA_OM dependencies on IC_TRAN_PND

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

990: AND w.delete_mark = 0
991: ;
992:
993:
994: CURSOR get_lot_tran (c_line_id ic_tran_pnd.line_id%TYPE) IS
995: SELECT itp.lot_id, itp.whse_code, itp.location
996: FROM
997: ic_tran_pnd itp
998: WHERE

Line 997: ic_tran_pnd itp

993:
994: CURSOR get_lot_tran (c_line_id ic_tran_pnd.line_id%TYPE) IS
995: SELECT itp.lot_id, itp.whse_code, itp.location
996: FROM
997: ic_tran_pnd itp
998: WHERE
999: itp.doc_type = 'OMSO'
1000: AND itp.completed_ind <> -1
1001: AND itp.line_detail_id = c_line_id

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

1132: -- END IF;
1133: /* end if generic_id has a value */
1134: /* fill in whse, customer name, bol no at end of code */
1135:
1136: /* get lot id from ic_tran_pnd */
1137: /* get lot no and name and sublot no from ic_lot_mst at end of code */
1138: /* (2 steps so non-sales-order loop can also use get_lot_info) */
1139:
1140: -- IF ord_cur_rec.alloc_qty > 0 THEN

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

1140: -- IF ord_cur_rec.alloc_qty > 0 THEN
1141: FOR lot_cur_rec IN get_lot_tran (ord_cur_rec.delivery_detail_id) LOOP
1142: tbl_hdr(tbl_ndx).lot_id := lot_cur_rec.lot_id;
1143: END LOOP;
1144: /* end getting lot id from ic_tran_pnd */
1145: IF tbl_hdr(tbl_ndx).lot_id is not NULL THEN
1146: FOR lot_cur_rec IN get_lot_info (tbl_hdr(tbl_ndx).lot_id) LOOP
1147: tbl_hdr(tbl_ndx).lot_no := lot_cur_rec.lot_no;
1148: tbl_hdr(tbl_ndx).lot_desc := lot_cur_rec.lot_desc;