APPS.WMS_CARTNZN_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 181: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp

177: t_lpn_alloc_flag_table lpn_alloc_flag_tb;
178:
179:
180: -- Table that needs to be passed inv_rcv_common_apis for splitting
181: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
182:
183: api_table inv_rcv_common_apis.trans_rec_tb_tp;
184:
185: -- This value is incremented and inserted into sequence_id of the table

Line 2011: FROM mtl_transaction_lots_temp

2007:
2008:
2009: CURSOR lots is
2010: SELECT lot_number, serial_transaction_temp_id, primary_quantity
2011: FROM mtl_transaction_lots_temp
2012: WHERE
2013: transaction_temp_id = p_transaction_temp_id;
2014:
2015: CURSOR serials(p_temp_id NUMBER, p_org_id NUMBER, p_item_id NUMBER) is

Line 3038: UPDATE mtl_transaction_lots_temp

3034: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_exp_date;
3035: END IF;
3036:
3037: /* Hack for sony */
3038: UPDATE mtl_transaction_lots_temp
3039: SET
3040: transaction_temp_id = curr_temp_id
3041: WHERE
3042: transaction_temp_id = l_temporary_temp_id;

Line 5382: mtl_transaction_lots_temp mtlt,

5378: mtlt.lot_number lot_num,
5379: mtlt.transaction_quantity lot_qty,
5380: msnt.fm_serial_number ser_num
5381: FROM mtl_material_transactions_temp mmtt,
5382: mtl_transaction_lots_temp mtlt,
5383: mtl_serial_numbers_temp msnt
5384: WHERE
5385: mmtt.transaction_temp_id = p_transaction_temp_id
5386: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)

Line 5656: mtl_transaction_lots_temp mtlt,

5652: mtlt.lot_number lot_num,
5653: mtlt.transaction_quantity lot_qty,
5654: msnt.fm_serial_number ser_num
5655: FROM mtl_material_transactions_temp mmtt,
5656: mtl_transaction_lots_temp mtlt,
5657: mtl_serial_numbers_temp msnt
5658: WHERE
5659: mmtt.transaction_temp_id = p_transaction_temp_id
5660: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)