DBA Data[Home] [Help]

APPS.WSH_OPM_CONV_MIG_PKG dependencies on IC_TRAN_PND

Line 61: FROM ic_tran_pnd ictran

57: , lot_id
58: , whse_code
59: , orgn_code
60: , location
61: FROM ic_tran_pnd ictran
62: WHERE ictran.doc_type = 'OMSO'
63: AND ictran.delete_mark = 0
64: AND ictran.staged_ind = 1 -- only for staged wdds, others lot_number is null
65: AND abs(ictran.trans_qty) > 0

Line 80: l_opm_table_name := 'IC_TRAN_PND';

76: , p_context => 'LOT_NUMBER_UPDATES'
77: );
78:
79: l_table_name := 'WSH_DELIVERY_DETAILS';
80: l_opm_table_name := 'IC_TRAN_PND';
81:
82: /* Get all the transaction record related to OM lines to be processed */
83: FOR opm_trans_rec IN get_opm_trans LOOP
84: GMI_RESERVATION_UTIL.println('NNNNn In transaction loop');

Line 89: GMI_RESERVATION_UTIL.println('ic_tran_pnd wdd id , so_line_id'||'l_wdd_id:'||l_so_line_id);

85:
86: BEGIN
87: l_so_line_id := opm_trans_rec.line_id;
88: l_wdd_id := opm_trans_rec.line_detail_id;
89: GMI_RESERVATION_UTIL.println('ic_tran_pnd wdd id , so_line_id'||'l_wdd_id:'||l_so_line_id);
90: /* get the new convention for lot_Number in R12 */
91: INV_OPM_LOT_MIGRATION.get_ODM_lot
92: ( p_migration_run_id => p_migration_run_id
93: , p_item_id => opm_trans_rec.item_id