APPS.INV_LABEL_PVT3 dependencies on MTL_MATERIAL_TRANSACTIONS_TEMP

Line 25: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

21: , x_msg_data OUT NOCOPY VARCHAR2
22: , x_return_status OUT NOCOPY VARCHAR2
23: , p_label_type_info IN inv_label.label_type_rec
24: , p_transaction_id IN NUMBER
25: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
26: , p_transaction_identifier IN NUMBER
27: ) IS
28:
29: ---------------------------------------------------------------------------------------------

Line 84: FROM mtl_material_transactions_temp

80: , organization_id
81: , inventory_item_id
82: , revision
83: , locator_id
84: FROM mtl_material_transactions_temp
85: WHERE transaction_temp_id = p_transaction_id
86: AND ROWNUM < 2;
87:
88: CURSOR c_mmtt_cart_lpn IS

Line 90: FROM mtl_material_transactions_temp

86: AND ROWNUM < 2;
87:
88: CURSOR c_mmtt_cart_lpn IS
89: SELECT cartonization_id
90: FROM mtl_material_transactions_temp
91: WHERE transaction_temp_id = p_transaction_id;
92:
93: CURSOR c_mmtt_pregen_lpn IS
94: SELECT lpn_id

Line 101: FROM mtl_material_transactions_temp

97: --Addd orgid, item id,rev for Conf Label ER
98: , organization_id
99: , inventory_item_id
100: , revision
101: FROM mtl_material_transactions_temp
102: WHERE transaction_temp_id = p_transaction_id;
103:
104: CURSOR c_wdd_lpn IS
105: SELECT lpn_id

Line 113: FROM mtl_material_transactions_temp mmtt

109: -- Bug 2825748 : WIP is passing a transaction_temp_id instead of
110: -- wip_lpn_completions,header_id for both LPN and non-LPN Completions.
111: CURSOR c_wip_lpn IS
112: SELECT transfer_lpn_id
113: FROM mtl_material_transactions_temp mmtt
114: WHERE mmtt.transaction_temp_id = p_transaction_id;
115:
116: -- For business flow code of 33, the MMTT, MTI or MOL id is passed
117: -- Depending on the txn identifier being passed,one of the

Line 403: mtl_material_transactions_temp mmtt

399: ppf.full_name requestor
400: FROM mtl_cycle_count_headers mcch,
401: mtl_cycle_count_entries mcce,
402: per_people_f ppf,
403: mtl_material_transactions_temp mmtt
404: WHERE mmtt.transaction_temp_id= p_transaction_id
405: AND mmtt.cycle_count_id = mcce.cycle_count_entry_id
406: AND mcce.cycle_count_header_id = mcch.cycle_count_header_id
407: AND ppf.person_id(+) = mcce.counted_by_employee_id_current ;

Line 2285: , p_input_param IN mtl_material_transactions_temp%ROWTYPE

2281: , x_msg_data OUT NOCOPY VARCHAR2
2282: , x_return_status OUT NOCOPY VARCHAR2
2283: , p_label_type_info IN inv_label.label_type_rec
2284: , p_transaction_id IN NUMBER
2285: , p_input_param IN mtl_material_transactions_temp%ROWTYPE
2286: , p_transaction_identifier IN NUMBER
2287: ) IS
2288: l_variable_data_tbl inv_label.label_tbl_type;
2289: BEGIN