[Home] [Help]
27: , x_msg_data OUT NOCOPY VARCHAR2
28: , x_return_status OUT NOCOPY VARCHAR2
29: , p_label_type_info IN inv_label.label_type_rec
30: , p_transaction_id IN NUMBER
31: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
32: , p_transaction_identifier IN NUMBER
33: ) IS
34: l_api_name VARCHAR2(20) := 'get_variable_data';
35:
371: , mmtt.cost_group_id
372: , mmtt.subinventory_code
373: , pp.NAME
374: , pt.task_name
375: FROM mtl_material_transactions_temp mmtt, mtl_transaction_lots_temp mtlt, pa_projects pp, pa_tasks pt
376: WHERE mtlt.transaction_temp_id(+) = mmtt.transaction_temp_id
377: AND mmtt.project_id = pp.project_id(+)
378: AND mmtt.task_id = pt.task_id(+)
379: AND mmtt.transaction_temp_id = p_transaction_id;
395: -- Bug 2673874 : joabraha
396: , pp.NAME
397: , pt.task_name
398: FROM mtl_txn_request_lines mtrl
399: , mtl_material_transactions_temp mmtt
400: , mtl_transaction_lots_temp mtlt
401: -- bug 3075322
402: -- , mtl_item_locations mil commented for bug 3776231
403: , wip_discrete_jobs wdj -- added for bug 3776231
436: -- Bug 2673874 : joabraha
437: , pp.NAME
438: , pt.task_name
439: FROM mtl_txn_request_lines mtrl
440: , mtl_material_transactions_temp mmtt
441: , mtl_transaction_lots_temp mtlt
442: -- bug 3075322
443: -- , mtl_item_locations mil commented for bug 3776231
444: , wip_discrete_jobs wdj -- added for bug 3776231
2859: , x_msg_data OUT NOCOPY VARCHAR2
2860: , x_return_status OUT NOCOPY VARCHAR2
2861: , p_label_type_info IN inv_label.label_type_rec
2862: , p_transaction_id IN NUMBER
2863: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
2864: , p_transaction_identifier IN NUMBER
2865: ) IS
2866: l_variable_data_tbl inv_label.label_tbl_type;
2867: BEGIN