[Home] [Help]
301: mmt.transaction_action_id mtl_action_id,
302: mmt.transaction_source_type_id mtl_src_type_id,
303: mmt.ship_to_location_id location_id
304: FROM mtl_unit_transactions mut,
305: mtl_material_transactions mmt
306: WHERE mut.serial_number = p_serial_number
307: AND mut.inventory_item_id = p_item_id
308: AND mmt.transaction_id = mut.transaction_id
309: AND mmt.transaction_id < p_mtl_txn_id
314: mmt.transaction_source_type_id mtl_src_type_id,
315: mmt.ship_to_location_id location_id
316: FROM mtl_unit_transactions mut,
317: mtl_transaction_lot_numbers mtln,
318: mtl_material_transactions mmt
319: WHERE mut.serial_number = p_serial_number
320: AND mut.inventory_item_id = p_item_id
321: AND mtln.organization_id = mut.organization_id
322: AND mtln.transaction_date = mut.transaction_date
2167: WHERE ct.transaction_type_id IN (117, 129, 128, 105, 112, 118, 119, 133, 132, 73,51) --Add WIP Assembly Completion for bug 7489949 --Added for ER#16265912
2168: AND ct.transaction_status_code = l_pending_status
2169: AND ct.inv_material_transaction_id is not null
2170: AND exists (
2171: SELECT /*+ no_unnest */ 1 FROM mtl_material_transactions mmt
2172: WHERE mmt.transaction_id = ct.inv_material_transaction_id
2173: AND mmt.inventory_item_id = nvl(p_inventory_item_id, mmt.inventory_item_id)
2174: AND mmt.organization_id = nvl(p_organization_id, mmt.organization_id))
2175: ORDER BY ct.inv_material_transaction_id; --Added hint for bug 9804454
2394: l_pa_project_task_id,
2395: l_distribution_acct_id,
2396: l_ship_to_location_id,
2397: l_mmt_quantity
2398: FROM mtl_material_transactions
2399: WHERE transaction_id = csi_txn_rec.inv_material_transaction_id;
2400:
2401: SELECT transaction_type_name
2402: INTO l_mtl_txn_type_name