210: (
211: trans_type NUMBER(2)
212: , item_no ic_item_mst.item_no%TYPE
213: , journal_no ic_jrnl_mst.journal_no%TYPE
214: , from_whse_code ic_tran_cmp.whse_code%TYPE
215: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
211: trans_type NUMBER(2)
212: , item_no ic_item_mst.item_no%TYPE
213: , journal_no ic_jrnl_mst.journal_no%TYPE
214: , from_whse_code ic_tran_cmp.whse_code%TYPE
215: , to_whse_code ic_tran_cmp.whse_code%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
216: , item_um ic_item_mst.item_um%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
217: , item_um2 ic_item_mst.item_um2%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
218: , lot_no ic_lots_mst.lot_no%TYPE DEFAULT NULL
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
219: , sublot_no ic_lots_mst.sublot_no%TYPE DEFAULT NULL
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
227: , orgn_code ic_tran_cmp.orgn_code%TYPE
220: , from_location ic_tran_cmp.location%TYPE DEFAULT NULL
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
227: , orgn_code ic_tran_cmp.orgn_code%TYPE
228: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
221: , to_location ic_tran_cmp.location%TYPE DEFAULT NULL
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
227: , orgn_code ic_tran_cmp.orgn_code%TYPE
228: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
229: , reason_code ic_tran_cmp.reason_code%TYPE
222: , trans_qty ic_tran_cmp.trans_qty%TYPE DEFAULT 0
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
227: , orgn_code ic_tran_cmp.orgn_code%TYPE
228: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
229: , reason_code ic_tran_cmp.reason_code%TYPE
230: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
223: , trans_qty2 ic_tran_cmp.trans_qty2%TYPE DEFAULT NULL
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
227: , orgn_code ic_tran_cmp.orgn_code%TYPE
228: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
229: , reason_code ic_tran_cmp.reason_code%TYPE
230: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
231: , journal_comment ic_jrnl_mst.journal_comment%TYPE
224: , qc_grade ic_tran_cmp.qc_grade%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
227: , orgn_code ic_tran_cmp.orgn_code%TYPE
228: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
229: , reason_code ic_tran_cmp.reason_code%TYPE
230: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
231: , journal_comment ic_jrnl_mst.journal_comment%TYPE
232: , attribute1 ic_jrnl_mst.attribute1%TYPE DEFAULT NULL
225: , lot_status ic_tran_cmp.lot_status%TYPE DEFAULT NULL
226: , co_code ic_tran_cmp.co_code%TYPE
227: , orgn_code ic_tran_cmp.orgn_code%TYPE
228: , trans_date ic_tran_cmp.trans_date%TYPE DEFAULT SYSDATE
229: , reason_code ic_tran_cmp.reason_code%TYPE
230: , user_name fnd_user.user_name%TYPE DEFAULT 'OPM'
231: , journal_comment ic_jrnl_mst.journal_comment%TYPE
232: , attribute1 ic_jrnl_mst.attribute1%TYPE DEFAULT NULL
233: , attribute2 ic_jrnl_mst.attribute2%TYPE DEFAULT NULL