APPS.INV_LABEL_PVT8 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 277: , mtl_material_transactions_temp mmtt

273: CURSOR c_delivery(v_cartonization_id NUMBER) IS
274: SELECT distinct wda.delivery_id
275: FROM wsh_delivery_assignments wda
276: , wsh_delivery_details wdd
277: , mtl_material_transactions_temp mmtt
278: WHERE mmtt.cartonization_id = v_cartonization_id
279: AND mmtt.move_order_line_id = wdd.move_order_line_id
280: AND wda.delivery_detail_id = wdd.delivery_detail_id;
281: l_delivery_id NUMBER;

Line 340: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

336: , x_msg_data OUT NOCOPY VARCHAR2
337: , x_return_status OUT NOCOPY VARCHAR2
338: , p_label_type_info IN INV_LABEL.label_type_rec
339: , p_transaction_id IN NUMBER
340: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
341: , p_transaction_identifier IN NUMBER
342: ) IS
343:
344:

Line 458: mtl_material_transactions_temp mmtt1,

454: nvl(mtlt1.transaction_quantity, mmtt1.transaction_quantity) transaction_quantity,
455: nvl(mtlt1.secondary_quantity, mmtt1.secondary_transaction_quantity) secondary_transaction_quantity, --Bug# 3596990
456: mtlt1.lot_number
457: FROM
458: mtl_material_transactions_temp mmtt1,
459: mtl_transaction_lots_temp mtlt1
460: WHERE mmtt1.transaction_temp_id = mtlt1.transaction_temp_id(+)
461: ) mmtt, -- mmtt with lot number information
462: wsh_delivery_details wdd,

Line 3267: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

3263: , x_msg_data OUT NOCOPY VARCHAR2
3264: , x_return_status OUT NOCOPY VARCHAR2
3265: , p_label_type_info IN INV_LABEL.label_type_rec
3266: , p_transaction_id IN NUMBER
3267: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3268: , p_transaction_identifier IN NUMBER
3269: ) IS
3270: l_variable_data_tbl INV_LABEL.label_tbl_type;
3271: BEGIN