APPS.INV_LABEL_PVT8 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 281: , mtl_material_transactions_temp mmtt

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

Line 344: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

340: , x_msg_data OUT NOCOPY VARCHAR2
341: , x_return_status OUT NOCOPY VARCHAR2
342: , p_label_type_info IN INV_LABEL.label_type_rec
343: , p_transaction_id IN NUMBER
344: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
345: , p_transaction_identifier IN NUMBER
346: ) IS
347:
348:

Line 476: mtl_material_transactions_temp mmtt1,

472: nvl(mtlt1.transaction_quantity, mmtt1.transaction_quantity) transaction_quantity,
473: nvl(mtlt1.secondary_quantity, mmtt1.secondary_transaction_quantity) secondary_transaction_quantity, --Bug# 3596990
474: mtlt1.lot_number
475: FROM
476: mtl_material_transactions_temp mmtt1,
477: mtl_transaction_lots_temp mtlt1
478: WHERE mmtt1.transaction_temp_id = mtlt1.transaction_temp_id(+)
479: ) mmtt, -- mmtt with lot number information
480: wsh_delivery_details wdd,

Line 3994: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE

3990: , x_msg_data OUT NOCOPY VARCHAR2
3991: , x_return_status OUT NOCOPY VARCHAR2
3992: , p_label_type_info IN INV_LABEL.label_type_rec
3993: , p_transaction_id IN NUMBER
3994: , p_input_param IN MTL_MATERIAL_TRANSACTIONS_TEMP%ROWTYPE
3995: , p_transaction_identifier IN NUMBER
3996: ) IS
3997: l_variable_data_tbl INV_LABEL.label_tbl_type;
3998: BEGIN