246: --select
247: --count(*)
248: --into l_mmtt_receipts_count
249: from mtl_material_transactions_temp mmtt,
250: mtl_transaction_lots_temp mtlt
251: where mmtt.organization_id = p_organization_id
252: AND mmtt.inventory_item_id = p_inventory_item_id
253: AND (mmtt.revision = p_revision
254: OR mmtt.revision is null and p_revision is null)
369: --select
370: --count(*)
371: --into l_mmtt_transfers_count
372: from mtl_material_transactions_temp mmtt,
373: mtl_transaction_lots_temp mtlt
374: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id
375: AND mmtt.inventory_item_id = p_inventory_item_id
376: AND (mmtt.revision = p_revision
377: OR mmtt.revision is null and p_revision is null)
401: --select
402: --count(*)
403: --into l_mmtt_transfers_count
404: from mtl_material_transactions_temp mmtt,
405: mtl_transaction_lots_temp mtlt
406: where decode(transaction_action_id, inv_globals.G_Action_Orgxfr, transfer_organization, mmtt.organization_id)= p_organization_id
407: AND mmtt.inventory_item_id = p_inventory_item_id
408: AND (mmtt.revision = p_revision
409: OR mmtt.revision is null and p_revision is null)
519: --count(*)
520: --into
521: --l_mmtt_lpn_receipts_count
522: from mtl_material_transactions_temp mmtt,
523: mtl_transaction_lots_temp mtlt
524: where mmtt.organization_id = p_organization_id
525: AND mmtt.inventory_item_id = p_inventory_item_id
526: AND (mmtt.revision = p_revision
527: OR mmtt.revision is null and p_revision is null)
641: CURSOR mtlt_cur IS
642: SELECT
643: mtlt.lot_number lot
644: FROM
645: mtl_transaction_lots_temp mtlt
646: WHERE mtlt.transaction_temp_id = p_mmtt_rec.transaction_temp_id;
647:
648: l_serials_exist VARCHAR2(1) := 'N';
649: l_return_status VARCHAR2(1) := NULL;
694: WHERE exists
695: (SELECT msnt.transaction_temp_id
696: FROM
697: mtl_serial_numbers_temp msnt,
698: mtl_transaction_lots_temp mtlt
699: WHERE mtlt.transaction_temp_id = p_mmtt_rec.transaction_temp_id
700: AND msnt.transaction_temp_id = mtlt.serial_transaction_temp_id);
701: EXCEPTION
702: WHEN no_data_found THEN