[Home] [Help]
299: mmt.transaction_action_id mtl_action_id,
300: mmt.transaction_source_type_id mtl_src_type_id,
301: mmt.ship_to_location_id location_id
302: FROM mtl_unit_transactions mut,
303: mtl_material_transactions mmt
304: WHERE mut.serial_number = p_serial_number
305: AND mut.inventory_item_id = p_item_id
306: AND mmt.transaction_id = mut.transaction_id
307: AND mmt.transaction_id < p_mtl_txn_id
312: mmt.transaction_source_type_id mtl_src_type_id,
313: mmt.ship_to_location_id location_id
314: FROM mtl_unit_transactions mut,
315: mtl_transaction_lot_numbers mtln,
316: mtl_material_transactions mmt
317: WHERE mut.serial_number = p_serial_number
318: AND mut.inventory_item_id = p_item_id
319: AND mtln.organization_id = mut.organization_id
320: AND mtln.transaction_date = mut.transaction_date
2022: WHERE ct.transaction_type_id IN (117, 129, 128, 105, 112, 118, 119, 133, 132, 73) --Add WIP Assembly Completion for bug 7489949
2023: AND ct.transaction_status_code = l_pending_status
2024: AND ct.inv_material_transaction_id is not null
2025: AND exists (
2026: SELECT 1 FROM mtl_material_transactions mmt
2027: WHERE mmt.transaction_id = ct.inv_material_transaction_id
2028: AND mmt.inventory_item_id = nvl(p_inventory_item_id, mmt.inventory_item_id)
2029: AND mmt.organization_id = nvl(p_organization_id, mmt.organization_id))
2030: ORDER BY ct.inv_material_transaction_id;
2168: l_pa_project_task_id,
2169: l_distribution_acct_id,
2170: l_ship_to_location_id,
2171: l_mmt_quantity
2172: FROM mtl_material_transactions
2173: WHERE transaction_id = csi_txn_rec.inv_material_transaction_id;
2174:
2175: SELECT transaction_type_name
2176: INTO l_mtl_txn_type_name