APPS.WMS_CARTNZN_PUB dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 105: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp

101:
102: SUBTYPE MMTT_ROW_TYPE IS MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE;
103:
104: -- Table that needs to be passed inv_rcv_common_apis for splitting
105: -- mtl_transaction_lots_temp and mtl_serial_numbers_temp
106:
107: api_table inv_rcv_common_apis.trans_rec_tb_tp;
108:
109: -- This value is incremented and inserted into sequence_id of the table

Line 1920: FROM mtl_transaction_lots_temp

1916:
1917:
1918: CURSOR lots is
1919: SELECT lot_number, serial_transaction_temp_id, primary_quantity
1920: FROM mtl_transaction_lots_temp
1921: WHERE
1922: transaction_temp_id = p_transaction_temp_id;
1923:
1924: CURSOR serials(p_temp_id NUMBER, p_org_id NUMBER, p_item_id NUMBER) is

Line 3018: UPDATE mtl_transaction_lots_temp

3014: inv_rcv_common_apis.g_order_lots_by := inv_rcv_common_apis.g_order_lots_by_exp_date;
3015: END IF;
3016:
3017: /* Hack for sony */
3018: UPDATE mtl_transaction_lots_temp
3019: SET
3020: transaction_temp_id = curr_temp_id
3021: WHERE
3022: transaction_temp_id = l_temporary_temp_id;

Line 5408: mtl_transaction_lots_temp mtlt,

5404: mtlt.lot_number lot_num,
5405: mtlt.transaction_quantity lot_qty,
5406: msnt.fm_serial_number ser_num
5407: FROM mtl_material_transactions_temp mmtt,
5408: mtl_transaction_lots_temp mtlt,
5409: mtl_serial_numbers_temp msnt
5410: WHERE
5411: mmtt.transaction_temp_id = p_transaction_temp_id
5412: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)

Line 5692: mtl_transaction_lots_temp mtlt,

5688: mtlt.lot_number lot_num,
5689: mtlt.transaction_quantity lot_qty,
5690: msnt.fm_serial_number ser_num
5691: FROM mtl_material_transactions_temp mmtt,
5692: mtl_transaction_lots_temp mtlt,
5693: mtl_serial_numbers_temp msnt
5694: WHERE
5695: mmtt.transaction_temp_id = p_transaction_temp_id
5696: AND mmtt.transaction_temp_id = mtlt.transaction_temp_id(+)